Displaying and Access Report Using VB? 1

[timoteo]

Can I connect to and display an MS Access report in a VB application. I know how to connect to a table and am wondering if I can do a similar thing with a report because I find the DataReport included with VB difficult to use.

Thanks in advance for any assistance!

Timoteo

 

[zemp]

In short yes.

First add a reference in your project to the Microsoft Access Object Library via the Project-references menu.

Second, declare the access application object.

Dim objAccAppl As Access.Application

Third, add the following code

Set objAccAppl = GetObject(&quot;<path to database>&quot;)
objAccAppl.DoCmd.OpenReport &quot;<report name>&quot;,acViewNormal

Take Care,

zemp

 

[timoteo]

zemp,

Thanks for the help. You have opened a whole new world of VB for me!

Just one follow up question if I may. Is there a way to display a report for review before printing it?

Timotoe

 

[zemp]

You should be able to change the 'acViewNormal' option to one that allows a preview. Check which options Access has.


Take Care,

zemp

 

[timoteo]

zemp,

Thanks again, I should have thought of this myself. The parameter is acViewPreview.

Timoteo

 

[dbspzin]

Hi all,
does any body know how can I change Icon and windows title in Access preview page when I display preview from VB.

Thanks