I've just started using Access Database and my boss says it needs a search on it. He only needs one criteria to search for a serial number. he wants to input a serial number and find out which order it goes to. I'm not to good at VB so explain carefully. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search Form Help
- Thread starter Smurfman
- Start date
you don't need VBA
Open the database and click the queries TAB
then Add your table
Next add the fields you want to see
In the Criteria for the serial number field
Put this
[Enter Serial Number]
Then run the query (click the Red Exclamtion mark)
Save the query.
next make a macro which opens the query
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
Open the database and click the queries TAB
then Add your table
Next add the fields you want to see
In the Criteria for the serial number field
Put this
[Enter Serial Number]
Then run the query (click the Red Exclamtion mark)
Save the query.
next make a macro which opens the query
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
