I have access database and want to create queries from command buttons, to select data according to designation.I need assistance on how to add these command buttons attach the select queries.
-
-
Moroke,
Welcome to Bytes. You'll find a lot of good help here.
One doesn't (generally) "create queries" from command buttons so much as launch queries with command buttons. I assume it is your case, but let's verify that.
Have you already made your queries? Have you made a form to put the buttons on, or are you thinking the buttons will be on a toolbar only?
You'll benefit a lot by spending some time going through the examples in the sample database that came with your copy of Access. The name of it is probably Southwind.mdb. By the time you finish reviewing those samples you'll feel like your own expert.
Jim -
Yes I want to launch with command buttons. I have made few queries and the form. Ideally was to just click a button and have a query likeRather than running the queries and the button just load already ran queries.Code:"SELECT *, FROM table; WHERE Classification='senior managers'"
But again I will follow your advice and review the database sample.
Thanks a lot.Last edited by zmbd; Mar 20 '14, 01:09 PM. Reason: [Z{Please use the [CODE/] button to format posted script and formated text - Please read the FAQ}]Comment
-
"Southwind. mdb" it's "Northwind" and depending on the version of Access the extention is either .mdb or .accdb
The newer version of the example database uses a lot of Macros to execute common tasks. Although not wrong, certainly doesn't help the novice learn VBA for the more advanced tasks.
Moroke, we also like to see what you've already attempted. Although we're willing to help, and many of use will give you shirt off our backs, we're also not a code writing service. Basiclly, we like to teach you how to fish, not just give you a fish (^_^)Comment
Comment