Another Access 2007 Question on Error Messages to appear.
Posted on 2012-09-13
I have problems writing some error messages and a thought about when someone retires or leaves and one has to get rid of the User listed in a table using VBA code.
On error messages, I need an error message to appear, on a Login screen. I want the user to enter their name as Last Name, First Name. If they do not enter the name in this way, I want to give an error message and exit the sub.
How can I write VBA code to check entering of name this way in the textbox?
Along this same line on error messages, I want the Access Type Textbox to be "Admin" or "User" if they put something else in the textbox, I want an error message to appear how can I check for this and exit the sub?
When a person retires or just leaves a job, I need a way to delete the user and password from a table holding this information. How can I do this? Do I just delete the person out of the employee table manually? I need a way to automate this?
Any help with these Access issues would be very helpful.