Web Development

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

Question

Locked

MS Access and VB Script

By mark.miller ·
We created a MS Access database from a text file. Using MS KB Article 210242 (http://support.microsoft.com/kb/210242/en-us) we were able to construct a query that returned the results we were looking for. However, we want the query to have the ability to search either on all of the parameters or simply on on a parameter, leaving all of the other fields blank, thereby creating a more global filtered results instead of a specific filtered result. I can use some help with constructing this query.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Recordset

by john.a.wills In reply to MS Access and VB Script

Put the query in a REcordSet in VBA. Depending on the buttons clicked, set the query equal to
"Select xyz from TheTable;"
or
"Select xyz from TheTable where abc = " & me.criterion &";"

Related Discussions

Related Forums