Recent content by hzeigler4

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