raymond3090
Registered User.
- Local time
- Today, 18:07
- Joined
- Sep 5, 2002
- Messages
- 43
Hi,
I'm relatively new to Access so this is probably super easy!
I would like to create a query using VBA, but I don't know how to go about doing it. I know how to set up my strings to be used as my SQL Where statements so that's not a problem. Once I have these, how do I open up a query based on this criteria.
Also, where do I place all this code? If I want the query to run upon clicking a command button, do I place it in the buttons on_click event? That would seem likely.
thanks
I'm relatively new to Access so this is probably super easy!
I would like to create a query using VBA, but I don't know how to go about doing it. I know how to set up my strings to be used as my SQL Where statements so that's not a problem. Once I have these, how do I open up a query based on this criteria.
Also, where do I place all this code? If I want the query to run upon clicking a command button, do I place it in the buttons on_click event? That would seem likely.
thanks
