VB & Database, Printing Access reports or using Access to print/preview reports

Printing Access reports or using Access to print/preview reports

Author	Message
TECHS - D2 #1 / 2	Printing Access reports or using Access to print/preview reports Include a reference to Access for Windows 95 and then you can use OLE automation to preview or print reports in Access 7.0 sub AccesReport() Dim objReport as Object Set objReport=CreateObject("Access Application") objReport.Visible=true objReport.OpenCurrentDatabase App.path & "\test.mdb" objReport.DoCmd.OpenReport "reportname", acPreview End Sub Johan Savels Royal Technical Shool of the Belgian Air Force ... Quote: >I was wondering if anyone knows a way to print/preview reports created >within Access from VB 4.0? I would like to do this outside of Access if at >all possible so that my users don't have to have access on their >machines... >Any help would be appreciated. >-- >-Eric Bonney > http://www.--*.com/
Sat, 18 Dec 1999 03:00:00 GMT

Stuart Greenbe #2 / 2	Printing Access reports or using Access to print/preview reports Quote: > I was wondering if anyone knows a way to print/preview reports created > within Access from VB 4.0? I would like to do this outside of Access if at > all possible so that my users don't have to have access on their > machines... > Any help would be appreciated. > -- > -Eric Bonney > http://home.fuse.net/ebonney/ Videosoft has an ActiveX control that will print Access reports. You can download a demo from their web page: http://www.videosoft.com The solution mentioned in another response requires Access to be installed on the user's machine. -Stu -- Coming soon to a browser near you... GUI Gumdrops - Tasty Morsels for Windows Users and Developers http://www.guigumdrops.com
Sat, 18 Dec 1999 03:00:00 GMT

Page 1 of 1

[ 2 post ]