Jump to content

moving and creating new records


This topic is 7858 days old. Please don't post here. Open a new topic instead.

Recommended Posts

i was wondering if this is possible.. might take some doing...

i am creating a time card database.. and i was wondering if it would be possible to create a script that on Monday morning would move all the records from the previous week into an "archive" database (and maybe aslo export them into an excel spreadsheet so that they can be printed out easily)... and then create a new record for each employee for the current week.

Link to comment
Share on other sites

ok i figured out how to move them to an archive database with a script basically i am going to make the script save a copy of the file.. which will work for my needs... now how would i go about deleting all the files from the database after i make a copy of it and then creating a new record for each person in the company..

or maybe a better solution would be to just wipe out everything in all the records except for the people's names, and then have the script change the dates in the database to the current week's dates..?? would this work??

Link to comment
Share on other sites

This topic is 7858 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.