Execute an Access Report from MSP VBA

[JimS]

How do I kick off an Access report (already written) from an MSP VBA program.
The MSP program creates a couple of tables the report uses as its source. I
want a button the MSP form to kick off the reports and print them.

Thanks in advance.

 

[Rod Gill]

You will need to use automation to open Access and then the relevant
database. You can then use the Run method on an Access application object to
run an Access VBA macro to display or run the report.

 

[JimS]

I'm accessing the db with ADODB. I can't use any ADO functions, huh? OK