I have a VB app in which I am calling an Access report. In the code to run the report, I am passing the 'acViewPreview' command so as to view the report. However, this does not happen. Does anyone have any idea how to preview an  Access report in VB prior to printing it?

The biggest reason for this is that the user may want to go back and produce just one additional page from the report or produce a page that was missed due to a printer jam etc... Without the preview option, the user cannot do this. They would have to print the entire report again for just one page.

Any information would be very helpful!

Thanks,

Brad

Hi bpears,
for me the best way is to put some references to Ms Access in your project and then u can manage all the thing in your db.
Also the report , if u ook in the object viewer there is all the object supported by this references.

Bye



____________________________
I don't mind not going to heaven
As long as they've got cigarettes
in hell

try this small code.......

Dim objAccess As Object

dbName = App.Path & "\ <database name>"
rptName = "<report name"
Preview = acPreview 'acNormal

With objAccess
    .OpenCurrentDatabase filepath:=dbName
    If Preview = acPreview Then
       .Visible = True
       .DoCmd.OpenReport rptName, Preview
    Else
       .DoCmd.OpenReport rptName
    End If
End With


gud luck c==|{======>