Setting up of 'Login" for users at Switchboard in MS Access2003

[ShyButterfly]

Hi there,
I want to setup a database where New Entries and Updates to the database is
documented. Eg: When ABC updates an entry, I want it recorded that that
person was the last to update that entry. This should be able to be done in
the 'Switchboard' right?
So, the question is "how do I set it up"?

With gratitude in advance,
The Shy butt!

 

[Todd Shillam]

Hi there,
I want to setup a database where New Entries and Updates to the
database is documented. Eg: When ABC updates an entry, I want it
recorded that that person was the last to update that entry. This
should be able to be done in the 'Switchboard' right?
So, the question is "how do I set it up"?

With gratitude in advance,
The Shy butt!

Create a field in your table that stores the records called UserName. On the form, create a textbox for username (make it hidden however). Then set the default value to the user's login name by using an environmental variable.

=Environ$("UserName")

This is one option.

Good luck,

Todd

 

[Douglas J. Steele]

While you're right that it's an option, Todd, I don't think it's a
particularly good one. Environment variables are extremely easy to reset,
and so should not be used in a situation such as this.

More appropriate is to use API calls to retrieve the ID from the operating
system. See http://www.mvps.org/access/api/api0008.htm at "The Access Web"
for sample code.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Create a field in your table that stores the records called UserName.
On the form, create a textbox for username (make it hidden however).
Then set the default value to the user's login name by using
an environmental variable.

=Environ$("UserName")

This is one option.

Good luck,

Todd