Re: "stamping" records by user
From: Rick B (anonymous_at_discussions.microsoft.com)
Date: 05/12/04
- Next message: Gerald Stanley: "Re: "stamping" records by user"
- Previous message: tina: "Re: Two Subforms - Same Record"
- In reply to: MCB: ""stamping" records by user"
- Next in thread: Gerald Stanley: "Re: "stamping" records by user"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 12 May 2004 13:34:46 -0500
Just enter =curentuser() in the timestamp field's default value, or
use code to place it there. Personally, I would use code on the before
insert to put the userid, date, and time.
Do a search if you would prefer to grab the login name from Windows and use
it.
Rick B
"MCB" <anonymous@discussions.microsoft.com> wrote in message
news:3CC9D66E-D22F-4B6F-B57C-889743B250CE@microsoft.com...
I don't think this is quite the same as the user tracking questions that've
been asked, but if so, my apologies.
In Access 2000, I have set up a workgroup with two levels of permissions.
All users are assigned to one of two groups. What the powers that be have
now asked for is basically an "entered by" field on the form where users
create a new case record (this database is medical-related). I could do this
manually, by making a drop-down list of usernames and making it mandatory
for the user to select his/hers when a new case is created, however, that's
clunky, and has little protection against errors (e.g. selecting the wrong
name).
Is there any way to grab the username from when the user logs in to the
database, and have that automatically populate the "entered by" field when
the user creates a new case? (Presumably a form of lookup.) Ideally, I don't
want to do this in VBA if I don't have to, since I have nearly zero
experience using it, and have had no luck getting anything to work in it
when I've tried.
Thanks in advance.
- Next message: Gerald Stanley: "Re: "stamping" records by user"
- Previous message: tina: "Re: Two Subforms - Same Record"
- In reply to: MCB: ""stamping" records by user"
- Next in thread: Gerald Stanley: "Re: "stamping" records by user"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
