Calling an Access(2000) report from VB6

[npolo]

How can I call a report in Access(2000) from VB6???

[JefB]

At the following URL (on Microsoft Knowledge Base), look for Previewing or Printing a Report. Also, read from the start since it shows you how to use Access objects :

http://support.microsoft.com/default...b;en-us;147816

Here is a short example:

Set objACCESS = CreateObject("Access.Application")
With objACCESS
.OpenCurrentDatabase strDatabase
.Visible = True
.DoCmd.OpenReport strReportName, acPreview
End With
Set objACCESS = Nothing

JeffB