Another Access 2007 Question on Error Messages to appear.

Hi everyone,

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.

jjc9809