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

how do I automate reports

100+
P: 143
My company maintains an access database. We use this database to generate a report 3 times a day and email it to a distribution list. How do I go about using the system clock to automate the report update and is it possible to have that emailed using outlook without having to open the database and manually do everything?
Dec 5 '06 #1
Share this Question
Share on Google+
2 Replies


100+
P: 143
You can either use code in an On Timer event of an unbound form, or you could use the Widows Scheduler. For the second part of your question, have a look here.

http://www.jephens.com/howtoemail.asp
Dec 5 '06 #2

100+
P: 143
Much Thanks, You will soon have made many people a little happier!!
Dec 6 '06 #3

Post your reply

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