Hello, I'm working on a project in Access 2000. I'm using a Parameter Query Dialog Box that will enable me to enter first name or last name, or first and last name as a concatenation, and in doing so will display all related records, so far so good.
However, if the name of the person that is being type in the dialog box isn't in the database, I would like to have a message box to indicate that the record isn't in the database, or something along those lines. Here's where I need you help. First of all, is it possible to accomplish such a task? Secondly how can such a task be accomplished?
In the query design, would using an IF Statement in SQL work? And if so, if you have any knowledge in that area, can you give me an example of what the syntax code would look like? Or, if there's another way, can you assist me?
Thank you...
However, if the name of the person that is being type in the dialog box isn't in the database, I would like to have a message box to indicate that the record isn't in the database, or something along those lines. Here's where I need you help. First of all, is it possible to accomplish such a task? Secondly how can such a task be accomplished?
In the query design, would using an IF Statement in SQL work? And if so, if you have any knowledge in that area, can you give me an example of what the syntax code would look like? Or, if there's another way, can you assist me?
Thank you...
