Is it possible to automate Access reports from outside of Access?
I currently use Access to generate reports from MySQL and DB2 databases. I'm basically using Access as a reporting frontend using Pass Through queries. Is it possible to automate report generation from outside of Access, maybe through the use of an API?
I have reports that need to be generated as events take place in the database. For example: if an order comes into our DB then a pretty PDF copy of that order needs to be sent via email back to the customer.
Yes, it’s possible in several ways:
1. Setup a macro in the app, then use the /x command line switch to execute the macro when the app opens.
2. Do basically the same thing, by using command line argument with the /CMD command line switch (more flexible)
3. Uses start up form code.
4. Control access with OLE automation from another application.
#2 is usually the best approach as it’s the most flexible and can be called from anything including the windows task scheduler
I have code that I can share that will help with that if you want .