Web Development



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 -


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;"
"Select xyz from TheTable where abc = " & me.criterion &";"

Related Discussions

Related Forums