English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

2 answers

you need to have a report designer in VB and design the report there, then you can execute a QUERY in Access and use that as the SOURCE for your VB REPORT.

2007-01-13 13:48:59 · answer #1 · answered by Richard H 7 · 0 0

To do this, you must have MS Access installed on the computer, along with appropriate MS Office Objects (Setup does this itself).
Then create an "Office.MSAccess" object in VB6 and call the DoCmd.OpenReport:

Dim oAccess As Object
Set oAccess = CreateObject( "Access.Application")
oAccess.OpenCurrentDatabase( "c:\mydb.mdb", Exclusive:=True)
oAccess.DoCmd.OpenReport( "Report")

2007-01-16 03:49:29 · answer #2 · answered by BataV 3 · 0 0

fedest.com, questions and answers