Grab User informaiton for Datbase updates

[N. Graves]

Hi,
I'm just in the development and planning stages of a new MDB. I would
like to require the person opening the database either login or supply
there name so if they make a change to table that there name would be
recorded on the transaction.

Does anyone have an examples of this process or could you please offer
your thoughts on this subject for the best way to achieve this.

Thanks

N. Graves

[Tom van Stiphout]

On Tue, 20 Apr 2004 08:20:57 -0400, N. Graves <ng*****@yahoo.com>
wrote:

One elegant solution is not to force the user to make a selection at
all, but to ask Windows who is logged in:
http://www.mvps.org/access/api/api0008.htm

-Tom.

Hi,
I'm just in the development and planning stages of a new MDB. I would
like to require the person opening the database either login or supply
there name so if they make a change to table that there name would be
recorded on the transaction.

Does anyone have an examples of this process or could you please offer
your thoughts on this subject for the best way to achieve this.

Thanks

N. Graves

[N. Graves]

I LIKE YOUR ANSWER!!!!!

Thanks... this was a great suggestion and very easy too

Tom you are the Man!
NG
On Tue, 20 Apr 2004 07:16:51 -0700, Tom van Stiphout
<to*****@no.spam.cox.net> wrote:

On Tue, 20 Apr 2004 08:20:57 -0400, N. Graves <ng*****@yahoo.com>
wrote:

One elegant solution is not to force the user to make a selection at
all, but to ask Windows who is logged in:
http://www.mvps.org/access/api/api0008.htm

-Tom.

Hi,
I'm just in the development and planning stages of a new MDB. I would
like to require the person opening the database either login or supply
there name so if they make a change to table that there name would be
recorded on the transaction.

Does anyone have an examples of this process or could you please offer
your thoughts on this subject for the best way to achieve this.

Thanks

N. Graves

[Tom van Stiphout]

On Tue, 20 Apr 2004 08:20:57 -0400, N. Graves <ng*****@yahoo.com>
wrote:

One elegant solution is not to force the user to make a selection at
all, but to ask Windows who is logged in:
http://www.mvps.org/access/api/api0008.htm

-Tom.

Hi,
I'm just in the development and planning stages of a new MDB. I would
like to require the person opening the database either login or supply
there name so if they make a change to table that there name would be
recorded on the transaction.

Does anyone have an examples of this process or could you please offer
your thoughts on this subject for the best way to achieve this.

Thanks

N. Graves

[N. Graves]

I LIKE YOUR ANSWER!!!!!

Thanks... this was a great suggestion and very easy too

Tom you are the Man!
NG
On Tue, 20 Apr 2004 07:16:51 -0700, Tom van Stiphout
<to*****@no.spam.cox.net> wrote:

On Tue, 20 Apr 2004 08:20:57 -0400, N. Graves <ng*****@yahoo.com>
wrote:

One elegant solution is not to force the user to make a selection at
all, but to ask Windows who is logged in:
http://www.mvps.org/access/api/api0008.htm

-Tom.

Hi,
I'm just in the development and planning stages of a new MDB. I would
like to require the person opening the database either login or supply
there name so if they make a change to table that there name would be
recorded on the transaction.

Does anyone have an examples of this process or could you please offer
your thoughts on this subject for the best way to achieve this.

Thanks

N. Graves