Paul has attended:
Access VBA course
Schedule Running a Macro
Hi,
I have a macro that I need to periodically run to append data to a snapshot analysis table.
The macro and the VB works fine but I need to find a way of getting the macro to run at the same time every week for consistency.
Any ideas?
Thanks
Paul
RE: Schedule Running a Macro
Hi Paul
Thank you for your question regarding scheduling.
Access does not include a method to automatically execute a procedure at a particular time unless the database was constantly open and a procedure constantly running to check the time. That causes issues with backups and is not a workable solution.
There are various products available that could open a file that executes code to manipulate your database, or your IT support team might already have a scheduling system that you could use.
Laura GB
