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

Access 2003 - Scheduled run and save a report

CougarMutt
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.

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


NeoPa
Expert Mod 15k+
P: 31,186
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.