Web Development·11,944 discussions

MS Access and VB Script

Locked

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.

Topic

Clarifications

In reply to MS Access and VB Script

Clarifications

Recordset

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 &”;”

[Author]

Replies