PDA

Click to See Complete Forum and Search --> : Connecting Password to multiple forms


woogie
Jul 11th, 1999, 12:14 PM
I am a very new newbie to VB, so I hope I put down all the information you need to help me with this.

- I am using VB 5.0
- I am using an Access Database (name, PIN, status, savings acct, checking acct)

I am working on a project that requires me to set up an ATM banking machine.

I have a splash screen, a login form, a 'regular user' form, a 'superuser form'.

After the splash screen has disappeared, the Login form appears and requests the user log in with name and password. A hidden label gets the status of the user (R for regular, S for superuser).

The database is connected to all forms.

I would like to do the following:
1 - when the user logs in on the login form, I would like to have the program validate the user based on the database (name, PIN, user status). So far, all I get is the name, PIN and status from the database rather than blank fields.
2 - When the user has been validated, I would like the database information to be the same for all forms. Right now, I could change the name on the login, but the account information remains as the first name in the database,
3 - How do I ensure the correct form displays for the right account (reg user as opposed to super user) eg: if Status = R, then go to regular user screen, else go to superuser screen?

I realize I may have not expressed myself correctly in giving you all the information you need. I hope you can help me.

Thanks in advance,
Kevin