Open Parameter MS-Access Report from VB6?

Question

First of all, Thanks in advance *_^

I am tring to open a parametr access report from VB6, in my Work project,,

I have found many ways to pass parameters to a query or stored procedures but i didn't found a way to pass them to a report,,

my report uses a single parameter query
this query uses another parametrer qurey

I just want a way to pass these parametrs from vb6 to open this report..


Waitnig ur hands on that please ,,, thanks alot *_^

Answer 1

Okay, If I have this right, you have a couple queries, one based on another. You can't set up a report that's databound to your Access table because the answer isn't in there until you run the double query.

So try this: Make a blank table with the fields you need as the result. Because of the double query, you might need a second blank table with the fields for the result of the first query. You'll have to figure that part out. Anyway, pass your parameter to the query and put the result in the blank database. Set up your report to be databound to the blank database fields, which by the time the query has run is no longer blank.

If you want to run it several times start by killing (deleting) the QueryResult.mdb and then making a copy of blank.mdb and renaming it QueryResult.mdb. So there will only be one set of data related to your most recent parameter.

Hope that helps

Answer 2

on your case that is what i'd want to do: a million) Import your record set into an excel spreadsheet. 2) Make a clean get get ideal of get proper of entry to to to/Excel connection from Crystals ( from Database professional) this would love to do what you're in search for for of. good fulfillment.