Search results

I actually need to import my existing staff data into another system. That is why I am trying to get in that format. Only so that it will import correctly into my new system. Otherwise the staff will be duplicated where as my software package allows the user to see a staff member and then all...

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...

whoo hoo! Worked like a charm! And I learned something new!! Thanks a million!

yes it is stored as text. I will try out date serial. Never used it before. Thanks

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!

Thank namliam but I do not need help creating the table Calendar0809. I already have something that recreates this every year. I do not quite understand what you are saying to do? How can I get whether it is a school day or not when the Calendar0809 table does not link to my students table? I...

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...

It is not a write issue because this is the crazy thing.... The report prints out for each individual in it. See "NAME" below: Report = Folder & "\" & Format(Date, "yyyy-mm-dd") & " " & Name & " rptPreschOutcomeExit.snp" There are about 25 names and it will actually print the first 4 reports...

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"...

Banana - question? If the user simply tabs over the description field without typing in anything the before update event is never fired. That is why I used the lost focus. I can't believe I am struggling so much with this. Any other ideas?

Awesome Rural guy!!! Works like a charm and the code is so simple!!! All seems clear to me now!

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?

Yes it does. Here is the database. Click Enter Employee Hours. I am trying to make the description and hours worked fields required. If the user leaves them blank it send focus back to textbox. Use Randy Jackson as the employee for testing and use the date 4/21/07

Has no one had this issue? I made a query that gets a list of the unmatched steps. Problem is, I need it to look at the Work order to see which ones it has already used and nt sure how to do that. Here is SQL from my query: SELECT tblStep.StepNbr, tblStep.StepDesc, tblStep.StepHrs...

The code is in the Lost focus event. It does not return an error, it simply moves to the next textbox on the form instead of focusing back to the description textbox.

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...

pbaldy, I feel stupid for not knowing this. I just assumed it would add it to the table. That option does work. CraigDolphin, That is awesome you were able to get my original idea to work. That is exactly what I wanted!!!!!! It all seems so easy!!!! Yes I realized that I will not be using an...