Solved select .. where (1 Viewer)

[Safari]

HI ALL ,

PLEASE I WANT TO MAKE QUERY USING VBA CODE

FORM NAME : STORES
COMBOBOX : STORE
COMMAND : COMMAND3

WHEN I PRESS COMMAND3 .. SELECT STOREID CODE FROM COMBOBOX THEN RESULT IN QUERY DEBEND ON COMBOBOX NUMBER

PLEASE HELP

 

[arnelgp]

check if this is correct.
view the code on the button.

 

[Pat Hartman]

If you don't know how to write SQL, start by using the QBE (Query By Example). Usually you start with a select query to select what you want from a table, then change the query type to Append or update is that is what you want to do. This will enable you to get the joins and other syntax right. Once it works, you can switch to SQL view and copy the SQL into your VBA. I don't do that for a variety of reasons that are not relevant to your question but it is not categorically wrong wo use embedded SQL so do whatever you want.

 

[oleronesoftwares]

If you don't know how to write SQL, start by using the QBE (Query By Example)

Following on @Pat Hartman's suggestion, below are two articles you can read.

MS Access - Query Data

MS Access - Query Data - A query is a request for data results, and for action on data. You can use a query to answer a simple question, to perform calculations, to combine data from different tables, or even to add, change, or delete table data.

www.tutorialspoint.com

Access 2016: Designing a Simple Query

When designing an Access query it can be simple or more complex. In Access simple query guidelines let you pull important data.

edu.gcfglobal.org

Also read up combo box properties to know which properties to manipulate.

Cheers

 

[Safari]

check if this is correct.
view the code on the button.

VERY GOOD

 

[Pat Hartman]

It is always nice when a good person like arnel does your work for you but he isn't always going to be available and at some point, you need to learn how to do it for yourself. The QBE is an excellent teacher.