Home > IT Answers > Access query LIKE operator search with msgbox if not found
draia
10 pts.
 Access query LIKE operator search with msgbox if not found
access criteria like operator
Here is the SQL version of my query criteria: WHERE (((tblMain.Subject) Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*")); In my query criteria it looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*".      My question is, if the user enters a first letter that doesn't exist I want a msgbox to pop up stating "not found" instead of just having a blank form open. Thanks for any help

Software/Hardware used:
Access 2010
ASKED: September 5, 2012  3:59 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _