-
February 16th, 2004, 02:40 PM
#1
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?
-
February 20th, 2004, 09:41 AM
#2
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.
-
February 20th, 2004, 12:37 PM
#3
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|