Originally posted by tupiex
Does anyone know how to access the MS Access reports trhough Visual Basic Version 6?
I'm not sure what you mean by this question... Do you mean reports inside a particular database?... If so, you can use automation to get at the reports... by declaring an Access Application, opening the database in question, etc... all inside your VB code... I've done VB front end's and Access back end databases before... Never had a problem...
Look up Automation in any Microsoft Office application Help and you'll get some information and examples... or post back for more help...
If I'm completely misunderstanding your question, I apologize...
I have an MS Access 97 database with some reports in it and I wanted to know if it would be possible to access these reports from Visual basic 6?
I have been working with VB only a short while so I do not know all the bells and whistles around the product but I have found that the VB reporting , in my opinion (not that I am an expert), is not as good as in MS Access.
Thus I was wondering if I read/display and print these reports using VB code.
Dim stDocName As String
Dim appAccess As Access.Application
Set appAccess = New Access.Application
appAccess.DoCmd.OpenReport myReportName, acPreview, , myCriteriaSQLOptional
appAccess.DoCmd.PrintOut acPrintAll, , , acMedium
Set appAccess = Nothing
If you like more information on how to do what you want check out the forum link below: