Tracking users

[fiona.innes]

Hi,

I have a booking systems database which has 2 tables tblemployee and
tblbooking. Employees make the bookings and also have the ability to
update the bookings once they are made. I know this sounds pretty
simple and currnently I have a drop down combo box that allows
employees to select there user name when they add a record, recently
some user have been selecting the wrong user name so i want to sent up
a login box before you access the booking form, so that each user who
adds records & amends records has to login to the booking form and
there username is actomatically records. Can anyone tell me how this
achieved?

Thanks
Fiona

 

[bhicks11 via AccessMonster.com]

Hi Fiona,

If you just want to capture the user ID:

Make a form (we'll call it BATCH) with an unbound control (we'll call it
COLLECT) on it to collect the login name. I would use a combobox with the
datasource either a table or list with all the possible user ID's (limit to
list if you want to only allow the users you have set up).

When the user select a login name (or keys a login name), open the booking
form. In the control for the user's ID, set the default value to forms!batch.
collect.

Or you could set up Access security and users - search in Help for user-level
security.

 

[bhicks11 via AccessMonster.com]

Forgot to mention, Make the BATCH form your defaul for the menu or
switchboard item.

Bonnie

http://www.dataplus-svc.com

Hi Fiona,

If you just want to capture the user ID:

Make a form (we'll call it BATCH) with an unbound control (we'll call it
COLLECT) on it to collect the login name. I would use a combobox with the
datasource either a table or list with all the possible user ID's (limit to
list if you want to only allow the users you have set up).

When the user select a login name (or keys a login name), open the booking
form. In the control for the user's ID, set the default value to forms!batch.
collect.

Or you could set up Access security and users - search in Help for user-level
security.

Hi,

[quoted text clipped - 11 lines]

Thanks
Fiona

 

[Douglas J. Steele]

The sample code in http://www.mvps.org/access/api/api0008.htm at "The Access
Web" shows you how to determine the user's ID without having to prompt them.
(Of course, if many people use the same computer without logging off in
between, that may not be what you want)

 

[bhicks11 via AccessMonster.com]

Wish I'd thought of that. I use it all the time too!

Bonnie

http://www.dataplus-svc.com

The sample code in http://www.mvps.org/access/api/api0008.htm at "The Access
Web" shows you how to determine the user's ID without having to prompt them.
(Of course, if many people use the same computer without logging off in
between, that may not be what you want)

Hi,

[quoted text clipped - 11 lines]

Thanks
Fiona