Replies

Can you explain to me why the specialweek goes up to 9? I have a process that runs on the 4th Friday of the month. I also have one that runs on the 1st Saturday after the first full week on the month.

I really appreciate your help.

Can you explain to me the process it would take to have a line item to print of the 4th Saturday of the month? We ahve several backup procedures that are activated on the 4th Saturday and the date varies.

Thanks,

Thanks, the light came on about an hour ago. I had named it processorder in the sample I was working on.

With your help, I think I may have something here!

Hans,
Can you explain to me what the sequence number is for?

I appreciate all your hard work. I spent several hours last night creating something similar but now I have more of a path to follow.

Thanks again for your help. I may be contacting you later for some additional direction.

Actually, Both.

I would like to enter it in access and print the check-off sheet. The problem we have right is that we have a tendency to skip some items because they are on the sheet everyday. Such as the 6th of the month. I think we get into a routine and forget to check dates. I would like for the program to look at the date and then extract the fields that are related for that date or day.

Thanks for your help.

Thanks for your help. The Dlookup worked perfectly and since the database is small, I think I will stick with it.

No gaps. Every employee starts with 1. Some have more and some had less visits. The data entry clerk manual enters the visit number and it is sequential. All visits are display on screen so she can see the next number.

The process is working great. The only problem is that it is not picking up the first date entry. I copied your code and made some moficiations for specs.

Thanks, I appreciate your help!

Let me ask you this question.
If I create a worksheet for each unit (people working in a different location) can I use the same code to pull each sheet over? Also, when does the code execute? Here is my thinking: the user enters all the information into excel. She goes to access to print a schedule – all the information is pulled in since I will link the workbook to access.

Thanks so much for your help.

I like the idea and I think it would work for me. I do have a few questions.

The user wants to be able to enter information by Month and by unit. I need to create a form that would select the unit of people, select the month and then populate the dates for that month. What would be the code to write the records back to my work schedule table? How do I get it to write to the next record? I programmed for years in cobol a long time ago and the logical steps would just appear and I could code. I guess the older you get and the longer you have been away from the process – you forget stuff. Here is my logical flow for this to happen and let me know if I am wrong in my thinking.

Select the month (dates populate on form)
Select the unit (employees populate on form)
Select time schedule under each date heading for each employee (the different shifts are in a table and I would use a combo box)
After I have entered all schedules for the unit (each person)- click a button to write.

In VBA code – once click to write
read a record, write Employee ID, Shift, first date to work schedule table.
Continue to record record write same employee id, shift and second date.
continue to I get to next employee and do the same.
When all employees for that unit are complete, select the next unit and do the same.

Is my logic correct?

Thanks for all your help.

The sheet actually looks like the attached.

The goal is to select a list of employees by their unit and then enter a work schedule for the entire month. The user does not want to view just one person at a time.

The idea was great and in any other situation I would use it. Any other suggestions!

Is there a way to take it from Excel and import into my tables?

I follow what you are saying below about using VBA code to make it happen. I did not think it would be an easy task in access. I have done something similar to this before but it was on a report not a data entry screen. I am struggling to get my form to pull up just my employees and the specific date range. I am somewhat familiar with VBA but I guess not savy enough. Is there a forum for VBA questions?

Thanks!

I currently have it in several excel spreadsheets. I need to track more information such as who called in sick and who is filling in for them as well as track my OT cost. Our current payroll system is just for “collecting” data, I need more to project future salary budgets, need for more staffing, etc.