can you print a report

dougvcd

07-06-2005, 02:17 PM

can you print a report from access 2003 in vb6
i have the report in access and was wondering if there is some code to print it without having to open database and do it that way
cheers
Doug

Bart1123

07-06-2005, 03:23 PM

Take a look in the MSDN for the Snap Shot Viewer. It is an Active X control that you can put on a form and have it show an Access report without opening up Access. I had a form with the control and code on it somewhere, but I seem to have misplaced it. A search of the forum provided a few threads, and a google search will provide more. Meanwhile I'll look for that project when I can.

Bart

loquin

07-07-2005, 09:45 AM

You can also use automation. In this case, VB opens its own instance of Access, using this instance to view or print the report.

Whoops - is this question related to this (http://www.xtremevbtalk.com/showthread.php?t=230125) post?

BTW. HERE's (http://www.microsoft.com/downloads/details.aspx?FamilyID=b73df33f-6d74-423d-8274-8b7e6313edfb&DisplayLang=en) the link to the snapshot viewer downlosd at MS

dougvcd

07-07-2005, 11:22 AM

Thank you all
now working ok
cheers
Doug