CODEWITHSUNDEEP
.netvbams-access
Jeffreybo
Jeffreybo

Reputation: 21

Generate Access Report

I am creating reports in MS Access. For now, every time I need to generate a report, I need to go to Access and run the report. Then, export it as PDF or send it over the email. I wonder if there is a way to automate this process. For example, I would like to schedule running the report at 6 am in the morning, and deliver it by email without manually doing them myself.

Is there a way to do it?

Thanks very much!

Upvotes: 2

Views: 57

Answers (1)

iDevlop
iDevlop

Reputation: 25272

Yes you can:

  1. Write an Access macro that saves the report to pdf then closes the app
  2. make a batch file to start Access opening myDb and the startup switch to start your macro ( /x myMacro).
  3. create a windows job that runs the batch file the desired interval

Upvotes: 2

Related Questions