CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2001
    Location
    Geogia
    Posts
    1

    Call an Access report to VB

    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.


  2. #2
    Join Date
    May 2001
    Location
    MO, USA
    Posts
    87

    Re: Call an Access report to VB

    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured