Display Report thru VB

[Guest]

How do I display my report using VB? I just want it to come up on a click_event. Thanks...Brad

 

[Cheryl Fischer]

You will need to use Automation from your Visual Basic app to open your
Access reports. MS Access must be installed on any computer running the VB
app:

Here are some links:

Access 97: Using Microsoft Access as an Automation Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;147816

Access 97: Using Microsoft Access as an Automation Server
http://support.microsoft.com/?id=210111

HOW TO: Use Automation to Print Microsoft Access Reports in Access 2000
http://support.microsoft.com/?id=210132


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

How do I display my report using VB? I just want it to come up on a

click_event. Thanks...Brad

 

[Guest]

I'm using the VB that is built into Access

 

[Cheryl Fischer]

You can use the command button wizard on a form to open a report. After
drawing the button on your form, the wizard will prompt you to select "the
action you want to happen when the button is pressed". Select Report
Operations from the ListBox on the left side of the window. You will then
see the appropriate choices for a report in the ListBox on the right side of
the window. Continue following the prompts and the wizard will generate
the VBA code needed to perform the desired Report Operation.