Time Cards - Excel Vs Access as option

Hi Ted,
Here's an update with some added bits and pieces. I've not added error handling as yet. Let me know where your problems occur.
Regards
Malcolm

MD, its getting closer to being perfect with every move you make.

I notice that when you enter data via the form it moves the display (top line of spreadsheet) to the next date for data to be entered, but it also boots you to the right. If you wanted to keep entering a weeks time data for Billy W is it possible to retain Billy's section so that you can review the data just entered to ensure its correct, then when you change to another employee it shows just their data as recorded?

Hi Ted,
The data entry should be working as you wanted. Can you step through the SetView sub to see if there is a problem there?. I'm having difficulty moving focus to the command button when time allocations are complete, not a real problem, but a neater use. I've commented out this line meantime.
I also added some instructions for "others"
Regards
MD

Can't replicate the error tonight.... must be an operator stuff up. ( well I'll admit it, it normally is where I'm involved)

Its also good to see the VBAExpress logo and hyperlink on the form. I'd still like to see where possible credit being given to those who have helped here..after all it'd still be just a rough concept loosely banging around in my simple mind.

MD, What is Module 3 supposed to be doing? It has more ActiveWindow.Scrollrows than fans at a soccer match.

Ted

Hi Ted,
Modules 2 and 3 can be deleted. Module 3 looks like I forgot to turn off my macro recorder (Yes, I still use it when making up code!)
Regards
Malcolm

Rofl.... and here I was thinking it was some new and un explained fancy code to cook chickens ( Scotland style).