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

Simple Password Form

P: n/a
I am building a simple access database for a small home business. I
have a table containing userid, password, and rights(either admin or
regular) which will simply stop someone from clicking on certain
command buttons. Setting up users and groups is really not neccessary
as it is just a few people logging in. The problem i have Is I can't
figure out how to return the rights value after the usrid and password
check ok. I can get it to log in just not return the value in the
rights column

Nov 15 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Could you not use a Dlookup function?

Something like dlookup("Rights_Field","Rights_Table","Rights_User ID =
forms!Form_Name_Where_ID_Is_Entered!Textbox_Name")

Allen's site will give you an insight into Dlookup
http://allenbrowne.com/casu-07.html

Mark

"Chuckles" <tm*****@new.rr.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I am building a simple access database for a small home business. I
have a table containing userid, password, and rights(either admin or
regular) which will simply stop someone from clicking on certain
command buttons. Setting up users and groups is really not neccessary
as it is just a few people logging in. The problem i have Is I can't
figure out how to return the rights value after the usrid and password
check ok. I can get it to log in just not return the value in the
rights column

Nov 15 '05 #2

P: n/a
Thanks Mark
That worked.
Great link also

Nov 16 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.