Hello, I am new to access and I have learned a lot with your videos but can I schedule a monthly export to excel on the first of the month and save it in a specific folder without having to open access? I don't want to depend on having a user to open access to trigger the export.
Regards,
Prado
Adam Schwanz
@Reply 2 years ago
Not with access alone. Access requires you to open it to fire any code.
You could setup something with windows though with like the task scheduler and possibly a batch file with the instructions.
It's HTA so would need some minor tweaks but because it's vbs it'll still work.
I'd advise switching to PowerShell or .NET but to give you an idea:
HTA - Advanced - Connect to an Access Database
Once you've got your connection you could get your data and export it to a csv or whatever you need.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
