copy data from one table to another on daily basis.

[florens]

Hi,

My problem is as follows:

I copy data from another applications database (which is paradox) to tables in my own database. One of these tables is employee.

My boss wants to be able to open a form (employee_add) and see all employees with their workingtime for the next working day. The next thing that should be done is to use a yes/no box if the employee is available that day. The availability and workingtime history should be kept available.

The way I've build up these tables is to have one table (resource) with the names and id's of the employee's. I have another table (employee) in which the workinghours, date, ID etc. should be stored to be able to keep a history. The problem is that I can't figure out how to copy the names of the employees from resource to employee every day.

Can somebody please help,

Thanks in advance

 

[h8IDs]

Have you looked into the Macro option that Access offers. If you are able to copy manually each day, creating a macro should work. To completely automate it, a script utilizing VBScript's "Date" command may perform the task daily. I have not tried to do this but from what I know I believe it is feasible.

 

[florens]

Thanks for the reply, I've tried to do it with a macro, and it works partly. How do I make if-then-else statements in macro's?