Print an ACCESS mdb report from visual basic frontend

[Stanley]

I would like to print an ACCESS mdb report from the visual basic frontend (
not from inside ACCESS). Is there a way to do this?

 

[Graham Mandeno]

Hi Stanley

No, you can't do this except from 'inside' Access.

However, you can get inside Access with COM automation. For example:

Set AcApp = CreateObject("Access.Application")
AccApp.OpenCurrentDatabase .....
AccApp.DoCmd.OpenReport ...