Re: CurrentUser function

There is nothing inherent with Access that will do that for you, but
you can easily code it into a form by using the BeforeUpdate event of
your form. Just populate the appropriate field with the CurrentUser()
function.


On Wed, 25 Jun 2003 17:24:58 -0700, "Mary" <jm_sandberg@hotmail.com>
wrote:

>I'd like to add a field to a table that automatcally adds
>the CurrentUser in a secure database. Each data entry
>clerk has a separate User Account. To audit accuracy, I
>need to know who entered a record. I'll also need to
>know who was the last employee to update a record.
>
>Any suggestions?
>Thanks,
>Mary


=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd

Mary,
When you say "updates are made using queries", do you mean users run the
query and then manually modify and/or add to the data pulled in the query?
If so, you should consider creating forms that use those queries as a Record
Source, then you can use the approach that Jack suggested. Forms are the
only objects that have Event Procedures that you can hook to do what you are
wanting.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



"Mary" <jm_sandberg@hotmail.com> wrote in message
news:09dd01c33bd0$f336b130$a501280a@phx.gbl...
> That will help, but some updates are made using queries.
> Any way I could enter code to track those updates?
> Thanks!
> Mary
> >-----Original Message-----
> >There is nothing inherent with Access that will do that
> for you, but
> >you can easily code it into a form by using the
> BeforeUpdate event of
> >your form. Just populate the appropriate field with the
> CurrentUser()
> >function.
> >
> >
> >On Wed, 25 Jun 2003 17:24:58 -0700, "Mary"
> <jm_sandberg@hotmail.com>
> >wrote:
> >
> >>I'd like to add a field to a table that automatcally
> adds
> >>the CurrentUser in a secure database. Each data entry
> >>clerk has a separate User Account. To audit accuracy,
> I
> >>need to know who entered a record. I'll also need to
> >>know who was the last employee to update a record.
> >>
> >>Any suggestions?
> >>Thanks,
> >>Mary
> >
> >
> >=======================================================
> >Jack MacDonald
> >remove UPPERCASE LETTERS from email
> address
> >Vancouver, B.C. Canada
> >Info about MSAccess user-level security
> >www.geocities.com/jacksonmacd
> >.
> >

I have set up forms for data entry, but the clerks are
able to use the queries to update data as well. They run
the query which prompts them for a specific employee,
then update the necessary information. They should be
using the form for updates, but they sometimes use the
query. (I think they're aware of the tracking when they
use the form). I've been asked to audit the database and
find out where the data entry errors are originating. As
long as they use the form I'm okay, but I'd like to be
able to audit any updates, whether it's in a table, query
or form. Do the newer verions of Access have this
capability? We're using Access 97 now, but have Access
2000 available if that would help.
Thanks again,
Mary

>-----Original Message-----
>Mary,
>When you say "updates are made using queries", do you
mean users run the
>query and then manually modify and/or add to the data
pulled in the query?
>If so, you should consider creating forms that use those
queries as a Record
>Source, then you can use the approach that Jack
suggested. Forms are the
>only objects that have Event Procedures that you can
hook to do what you are
>wanting.
>
>--
>Lynn Trapp
>MS Access MVP
>www.ltcomputerdesigns.com
>Access Security: www.ltcomputerdesigns.com/Security.htm
>
>
>
>"Mary" <jm_sandberg@hotmail.com> wrote in message
>news:09dd01c33bd0$f336b130$a501280a@phx.gbl...
>> That will help, but some updates are made using
queries.
>> Any way I could enter code to track those updates?
>> Thanks!
>> Mary
>> >-----Original Message-----
>> >There is nothing inherent with Access that will do
that
>> for you, but
>> >you can easily code it into a form by using the
>> BeforeUpdate event of
>> >your form. Just populate the appropriate field with
the
>> CurrentUser()
>> >function.
>> >
>> >
>> >On Wed, 25 Jun 2003 17:24:58 -0700, "Mary"
>> <jm_sandberg@hotmail.com>
>> >wrote:
>> >
>> >>I'd like to add a field to a table that automatcally
>> adds
>> >>the CurrentUser in a secure database. Each data
entry
>> >>clerk has a separate User Account. To audit
accuracy,
>> I
>> >>need to know who entered a record. I'll also need to
>> >>know who was the last employee to update a record.
>> >>
>> >>Any suggestions?
>> >>Thanks,
>> >>Mary
>> >
>> >
>>
>=======================================================
>> >Jack MacDonald
>> >remove UPPERCASE LETTERS from email
>> address
>> >Vancouver, B.C. Canada
>> >Info about MSAccess user-level security
>> >www.geocities.com/jacksonmacd
>> >.
>> >
>
>
>.
>