CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    PA
    Posts
    3

    firing an access report from VB

    I have a report in access that runs off of a query. The query prompts the user for a value for one of the fields. I need VB to run this report and insert the value into the query form when it pops up. Can this be done? Right now I click on report it fires off the report but gives me the message that access needs more info and gives me the option to switch to access and enter the info manually. Any ideas?

  2. #2
    Join Date
    Jun 2002
    Location
    Clane, Ireland
    Posts
    766
    Change the report to run from a table, and build the table before running the report. You can populate the parameters into your query from VB, write this out to a table and then call the report.

    HTH
    JP

    Please remember to rate all postings.

  3. #3
    Join Date
    Oct 2003
    Location
    Philadelphia, PA
    Posts
    167
    or depending on what you want to do, you coudl just code your sequence in VBA in access since it seems that most of your work is being done from there!
    Mike Dershowitz
    miked@lexientcorp.com
    www.lexientcorp.com

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