I'm fairly new to ADO and I'm trying to figure out how to search for a field inside an Access Database by using Excel VBA. I am able to retrieve a record by finding a value in a particular field, but when the field is not found is when I'm having the issue.
I would like to have an if statement or other workaround where if the field value I am looking for is not found, then a userform will popup to prompt the user to register their information. if I can just get the syntax down on how to do something else when the field is not found, I will be okay.
Below is the vba code I am using in Excel...
I am retrieving the user's Windows Logon ID, and then going to Access to Retrieve their email address from a table named Employees.
Please Login or Register to view this content.