By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 975 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Access 2003 - Scheduled run and save a report

P: 7
Is there a way to initiate access, run a report, save it to a network location, and exit the application all from a scheduled task?

Emailing it would be just as good, but if I can save it that would be OK also.

Dec 19 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
I'm not sure if Access startup parameters can be passed into the VBA code, but certainly it's possible to start a database from the command line (hence also a scheduled job). A form can be started automatically when a database is opened, so you have your facility for running the code (OnOpen event procedure of the form) from a scheduled job ;)
Dec 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.