currentuser to populate a field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Willliams - 29 Jul 2005 11:58 GMT

Hi all

I have a quick question.... I would like the currentuser to populate a field
in a table. I have tried using the =currentuser() function without effect. If
i add it on a form then it defaults the whole table to that user. I would
like the current user to be recorded against each record

Does any one have any ideas how i can do this???

Cheers

Paul

Signature

It''''''''''''''''s Just a ride

Reply to this Message

Nikos Yannacopoulos - 29 Jul 2005 12:13 GMT

Paul,

Add a text field in the table to hold the user information; add a
textbox in the form, bound to that field, and set its default value to
=currentuser(). This will do it for all new records created. Note: the
textbox doesn't have to be visible!

HTH,
Nikos

Reply to this Message

Duane Hookom - 29 Jul 2005 13:33 GMT

This assumes that security has been enabled in the application.

Signature

Duane Hookom
MS Access MVP

> Paul,
>
[quoted text clipped - 5 lines]
> HTH,
> Nikos

Reply to this Message

Paul Willliams - 31 Jul 2005 09:37 GMT

Is there no other way.. Currently I have no security. This will be a later
addition is there another way.. Say to pick up the windows login????

Signature

It''''''''''''''''s Just a ride

> This assumes that security has been enabled in the application.
>
[quoted text clipped - 7 lines]
> > HTH,
> > Nikos

Reply to this Message

Duane Hookom - 31 Jul 2005 17:36 GMT

You can use the function found at http://www.mvps.org/access/api/api0008.htm
as the default value of a control on a form.

Signature

Duane Hookom
MS Access MVP

> Is there no other way.. Currently I have no security. This will be a later
> addition is there another way.. Say to pick up the windows login????
[quoted text clipped - 11 lines]
>> > HTH,
>> > Nikos

Reply to this Message