VBA Code Help for Saving a Table on a certain day of every week

[dahlt]

Hello,
I am trying to find out what VBA Code I should use for a way to save a main table name: Master_Template on a certain day of the week (weekly) to happen automatically on close of the database - of course on that certain day of the week.

Could someone help me with this project? I have been using the almighty Google for hours today and thought I should at least ask here. - I hate giving up on trying to figure out things on my own

Sincerely - Tracy

 

[spikepl]

Define "save a main table".

Data in access tables is (largely) saved the moment it is entered so what do you mean?

 

[dahlt]

Ahh, yes sorry about that - well each week we are saving that "main" table: Master_Template as a certain date and format name.
We run lab scheduling and once the week is over on a Friday we would do a save object as to the Master_Template to be saved as that same week's Monday's date in the format of example: FTAUSED0105 so that the upcoming week we place another weeks schedule into the Master_Template once again (we rotate the data every week and save the table off every week) a new person has been working the process and keeps forgetting to save it and this causes issues on the metrics ends of things here. So I need something automatic to happen on a Friday of every week to do a save object as (for that current Monday's date in that format)

 

[spikepl]

Now I'm really confused. A table has a name, it has a definition, and it can contain data. Which of the above do you change and "save" and where, and what do you do with the previous version of same?

Your entire process sounds very unusual - please be specific in your answer.

 

[dahlt]

I open the Database and go to tables view, highlight the table Master_Template and do a save object as name it FTAUSED0105 this creates the new copy of the data for current week in that same database under tables view. After that save we then either:
1. open Master_Template do a select all (Ctrl+A) and delete all data and use an entry form to re enter the new weeks data or
2. Delete the Master_Template table from current week and import another Master_Template table from a future week schedule
We create three weeks of schedules for the FAA to test in labs using three database copies one for current week, one for future week and a third week
I normally swap tables out on a weekly basis but during all of this we also need to SAVE the data off in the databases so we can report to management the lab utilization for metrics purposes.
It is THE SAVE process that keeps getting missed and this causes more time in having to "reenter the schedule" from a PDF version exported out previously.
I am looking to automate the SAVE OBJECT AS step in this process so it is not missed on a weekly basis.
Is there a VBA code where the database can automatically save the Master_Template table with a certain name/date format like: FTAUSEDXXXX (xxxx=mmdd) for that week on a certain day of the week the admin is in the database on a (onclose) action?

 

[spikepl]

Ok . you have described some mechanics I'm not sure I fully understand. Now - this is is not a normal usage of a db, so what is the reason for doing this process like this?

Normally you have same type of data in one and only one table, and each data set you just tag by date, name, whatever to discern it, and you use queries to export/extract data sets of interest. doing it like that would obviate the nee dfor some "renaming" routines entirely.