pass parameters to query and then print report

[wendywam]

Hi
I am developing a vb5 application and microsoft access 97 is my database. I have to print a report based on the parameters that i enter on the vb form (textbox). i have a query in access db which i have to pass two parameters to in order to display results. How do i call that access query in my vb program and then print a report.I dont want the popup parameter box to come up.
I can do this with vb5 and sql 6.5 but not with vb5 and access 97. please help.

 

[KenReay]

Hi

Sounds like you need to usethe .parameters collection of the querydef

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[wendywam]

Hi Ken Reay
I tried what you suggested and it does not work.
Any ideas or suggestions guys?

 

[scriverb]

How about creating a single record table in your ACCESS database and updating a couple of parameter fields of the correct type with your vb forms input. Then the ACCESS query can include that table in its structure and use the parameter fields in its criteria expression.

Just an idea.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[KenReay]

Hi

"it does not work.", what happened?


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[wendywam]

Its a good idea Bob Scriver.
I will use it.
Thank you very much.