Search results

I have a table of all staff members. A staff member can work at more than one location. The currecnt staff table I was given contains a record for every location they work. For instance: Name Location Heather Office A Heather Office B Heather Office C Sarah Office A Tom Office B Tom Office D...

I have a table of all staff members. A staff member can work at more than one location. The currecnt staff table I was given contains a record for every location they work. For instance: Name Location Heather Office A Heather Office B Heather...

This is driving me crazy! I have a table that contains the DOB of students in this format: mmddyy. It is a two digit year. How can I calculae the student's age? I cannot use the date diff function because that only works on a four digit year. HELP PLEASE!

OK I am going to see if I can explain this. I have a table named Calendar0809. This table has a list of school dates and whether the date is an actual school date or not. I am attaching this table. Then I have a table that lists students names, a start date, and an end date. A student may have...

I have a report in access that I save on the network as a snapshot in a designated folder. I can run this and it works fine. However it does not work for my coworker. She gets the error: "The report snapshot was not created because you dont have enough free disk space for temporary work files"...

I want to force the user to only enter hours in these amounts. For example: have a textbox on a form called hours worked. If the employee worked 4.33 hours the user must enter in 4.50 hours instead. I do not want to except any decimal values other than those listed abouve. Anyone know how?

I am trying to require two fields on a subform. One is Description. Here is the code I have in the lost focus event: If IsNull(Description) Then MsgBox "Description Required", vbOKOnly + 64, "Description" DoCmd.CancelEvent Me.Description.SetFocus End If However it does not set the focus back...

I have a form Called Work Order Entry that displays details about a work order. It contains a subform listing certain steps used for that work order. There is a button "Add more steps" Which pops up a form allowing them to enter a new step and it is then added to the step subform. I would like...

I have a Main form frmEditWO that contains the subform subfrmWOStep. A user will select an existing Workorder. Then they have the option to Add a step used by clicking on the "Add a Step" buttun. This opens a regular form frmNewWOStep and brings the Work Order ID with it. The user then selects...

I have a main form that allows the user to select a workorder from a combo box. This will filter my continuous subform below it. I then want the user to enter any parts used for this work order. Here is the problem. The user can select an existing part or enter a new one(but I do not want the...

Ok now I have an issue with totaling on the subform. I have a main form(frmEmpHours) and a subform(subfrmEmpHours). I added a textbox to the sub forms footer to total the number of hours. When I open the main form, you select an employee(first on in the list) then enter a date(for testing...

Hi all. I have read tons of posts on here and cannot find exactly what I am looking for. I have a main form that contains a continuous subform. The main form has the user select and employee from a combo box and then has them enter a dtae. I would like to show only those records with that...

I have a form that allows a user to add a new family or edit a family. When the user clicks the save button, if they are adding the family for the first time, I want to enter todays date in a field(Date added). If they are editing the family info I want to add todays date in the filed(Date...

I have a form(Family Info) that has a combo box containing a list of family names. The form displays details about the family based on the family selected in the combo box. I have a button on this form to Add a Family. This opens a blank form to enter a new family. When I click the save button...

I have an unbound textbox on an unbound form. it is set as visible, enabled, and is NOT locked! But when I open the form and try and type in the textbox nothing happens. It will not let me type anything(numbers, characters, etc) Does anyone know why? I want the user to type in the week number...