Click to See Complete Forum and Search --> : Call an Access report to VB


mikewilson55
August 31st, 2001, 12:02 PM
How to call an access report into my VB 6.0 project. I prefer to make my reports using Access but I do not know how to retreive them for the user to view. The main Data Source is the same database the reports are located in.

midnightservice
September 2nd, 2001, 07:55 PM
add in a dataevvironment and then set your connection on the environment then add a command and choose your report from there in table view.
then add in a data report and set the source to the dataenvironment and the member to the command
then right click on the report design in the detail field then choose retrieve structure then drag the command into the detail field and release and the arrange the lables and fields the way you want them... goto your form and add a button then goto code and put in the reportname.show to view it or reportname.printreport false to print strait to the printer or reportname.printreport true to get a printer dialog box

good luck

midnightservice