Solved Combobox special value (1 Viewer)

tihmir

Registered User.
Local time
Today, 05:02
Joined
May 1, 2018
Messages
257
I want to make 3 accde files on my database for 3 people. In my database I have a form with combobox with 3 names (name1, name2, name3) of that people to make their reports. So I want when the name1 open his accde file, in that form with combobox to see In that combobox only his name (name1) to be able to create a report only for him . Мy idea is that name 2 would not be able to create a report for name 1 and see it
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:02
Joined
Oct 29, 2018
Messages
21,358
Best approach, if you can, is use the network login information, if it's available. Then, you wouldn't need three different versions of the same ACCDE.
 

zeroaccess

Active member
Local time
Today, 07:02
Joined
Jan 30, 2020
Messages
671
I highly recommend you make a tblUsers.

Add your 3 users, maybe a 4th for yourself as Admin.

Detect the user on startup using a Login form.

Set a TempVar equal to the primary key of the detected user.

Use that value as the default value in various places (locked controls, etc).
 

tihmir

Registered User.
Local time
Today, 05:02
Joined
May 1, 2018
Messages
257
Тhank you for the advice. It is done.
 

Users who are viewing this thread

Top Bottom