TimeSheet db: How to enter a weeks records with Date Incremented?

[jezjez]

Hi

Ok, guys; probably a simple one but its got me:

I maintain a Time Tracking db for office workers. They log in and select the task, billing code, number of hours per task worked etc.

I need a 1 click solution for the users to enter a weeks records at a time - eg for vacation, illness or a weeks training course. Currently they have to enter a record for each day. Most fields are automatically populated (based on defaults they can specify elsewhere) but it still means about three clicks per day which for a two week vacation starts to add up.

I am an intermediate VB/Access admin so could handle answers using a date range specified through a calendar form or just a solution where the user just clicks SUBMIT for each day and the date is incremented.

Over to you. Thanks in advance for any help...this one has driven me nuts!

cheers Duncan

 

[doran_doran]

Post the DB

Can you post the database in Access97 format? I can take a look at it.

 

[jezjez]

hi doran,

its Access 2000...

 

[jezjez]

i just tried to convert it to 97, but it said i lack some key components and now wont let me open it (lucky i made the backup..)

i am going home now, perhaps we can hook up Monday to see if you are able to save me.. ?

cheers