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

 

[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)