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

restricting access to records based on user identity

P: n/a
I have a database for warranty claims. There is one form based on one large
table. The first object is a combo box asking for dealer number. When that
field is updated the dealers name, address, and phone number appears in some
text boxes. When the dealer selects their dealer number I would like a
password field or dialog box to appear. If the dealer enters the correct
password then they will be able to see the warranty claims that pertain to
them and no one else. If the dealer enters the wrong password a simple
dialog box should be displayed saying incorrect password with an OK button.

I like this method, and am trying to get it to work, but if anyone has a
simpler idea that would be great too.

Thanks for any help,

Shannan Casteel

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
so, what's not working ?

Nov 13 '05 #2

P: n/a
Hi Shannan,

This anwer assumes you have security on your database, else you are not
going to stop them from seeing other dealer claims anyway.

I would have them logon using their dealer ID number
Logon
Name: 10
Password: ******

Change the combo box to a text field (lngDealerNumber) and in the on_open
event of the form put in:
lngDealerNumber = CurrentUser
the next line in the on_open form event should be your Update Event to
populate your form.

Regards,
Barry
""Shannan Casteel via AccessMonster.com"" <fo***@AccessMonster.com> wrote in
message news:50***********@AccessMonster.com...
I have a database for warranty claims. There is one form based on one large
table. The first object is a combo box asking for dealer number. When that
field is updated the dealers name, address, and phone number appears in some
text boxes. When the dealer selects their dealer number I would like a
password field or dialog box to appear. If the dealer enters the correct
password then they will be able to see the warranty claims that pertain to
them and no one else. If the dealer enters the wrong password a simple
dialog box should be displayed saying incorrect password with an OK button.

I like this method, and am trying to get it to work, but if anyone has a
simpler idea that would be great too.

Thanks for any help,

Shannan Casteel

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #3

P: n/a
Thanks for your thoughts on this.

Ok, I got the text box to display the user, but how do I use this to restrict
what records that user sees. Do I have a table design issue? I have 60
something dealers, surely I don't have to create 60 tables and load each
table and respective form for each user.

I guess what I'm asking for is some more code to use so that when the text
box displays USER #1 then only the claims that USER #1 has submitted would be
visible or accessable.

Thanks for your time.

Shannan

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #4

P: n/a
By the Way,

I haven't set up securtiy.....Yet.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #5

P: n/a
Also, the number of dealers is constantly changing. The dealer # comes from
a linked excel spreadsheet.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #6

P: n/a
You need security!

""Shannan Casteel via AccessMonster.com"" <fo***@AccessMonster.com> wrote in
message news:50***********@AccessMonster.com...
By the Way,

I haven't set up securtiy.....Yet.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.