By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,703 Members | 1,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,703 IT Pros & Developers. It's quick & easy.

Set properties

P: 1
In my database there are two type of Users "Administrator"and "Regular user". Now when any user login into the database through the login Form, where user has to enter password and UserName, which takes him to the WelcomeForm. This Welcome Form has to Buttons. One is "Customer "and Another one is "add Customer".

Now my problem is when "Regualr User" login through login form, it should display only the "add Customer" button on the welcome form. Here I am attaching the code of login Button.

If uFound = Password.Value And vFound = UserName.Value Then
DoCmd.Close
stDocName = "WelcomeForm"
DoCmd.OpenForm stDocName

Please let me know if anybody has any clue
May 29 '07 #1
Share this Question
Share on Google+
1 Reply

MMcCarthy
Expert Mod 10K+
P: 14,534
In my database there are two type of Users "Administrator"and "Regular user". Now when any user login into the database through the login Form, where user has to enter password and UserName, which takes him to the WelcomeForm. This Welcome Form has to Buttons. One is "Customer "and Another one is "add Customer".

Now my problem is when "Regualr User" login through login form, it should display only the "add Customer" button on the welcome form. Here I am attaching the code of login Button.

If uFound = Password.Value And vFound = UserName.Value Then
DoCmd.Close
stDocName = "WelcomeForm"
DoCmd.OpenForm stDocName

Please let me know if anybody has any clue
Where do you get vFound from?
Jun 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.