show report in visual basic application

[tweetie22]

Hi, I am Using VB 6 and access 2000, I have Developed a program with VB, and everything is there but now I need VB to take a Report made in Access, how do I do that?

 

[FoFa]

1. Create a macro inside of access that opens the report.
2. From VB you can open the access database and specify which macro to run.

example of vb code:

Shell "c:\program files\microsoft office\office\msaccess.exe db1.mdb /x mymacro"

of course you will have to adjust the path, database, and macro name accordingly.

 

[pono1]

FoFa's code is good -- the following works too, assuming the Access Reference Library is added to your project.

Dim acApp As Access.Application
Set acApp = New Access.Application

'path to DB file
acApp.OpenCurrentDatabase ("\\servername\FolderXYZ\DB1.mdb")
acApp.DoCmd.OpenReport "Rpt1" 'send rpt to printer
acApp.CloseCurrentDatabase

Regards,
Tim