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.

1 total post (Page 1 of 1)  
| 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 &";"

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums