Solved select .. where

[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 - Learn how to query data in MS Access effectively with practical examples and detailed explanations.

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.