How can i print a access report from visual basic?
Printable View
How can i print a access report from visual basic?
It took me forever to find this code, but got it in one of the best db books around.. Database Access With VB6 by Jeffery Mcmanus..
' you need your access ref obj lib
Dim MSACCESS as Access.application
Private Sub PrintReport_Click()
Set MSACCESS = New Access.Application
MSACCESS.OpenCurrentDatabase ("c:\your dir\Your.mdb") ' This opens your db..
MSACCESS.DoCmd.OpenReport "YourReportHere", acViewNormal This actualy opens your report from your Access (97?) db & then prints it..
MSACCESS.CloseCurrentDatabase ' self explanitory
Set MSACCESS = Nothing ' You need this, or you will keep access in memory & lag the user..
There you have it!!! Use this code well & may all your reports print perfect!
------------------
~\*/~ Thank you....
tHaNk YoU!!
Will give it a try!
No probs.. If you change the view style you can preview the report before printing as well.. It is a cool VBA trick..
------------------
~\*/~ Thank you....
HI, Zonnix / LordCallubonn
How can I Send parameter to the report
e.g. : From/ To Date
Please email me directly as my email has changed and I don't know how change it on the BB.
[email protected]
Thanx