Hi,

I have several tables in an Access 2003 database.

On each one I have 4 columns - 2 for 'created by' user and date and two for
'amended by' user and date.

How do I populate these columns on Add new or Update row with the NT ID?

thanks for any help.

Philip

Here is the code to get the user name:
http://www.mvps.org/access/api/api0008.htm

Use the BeforeUpdate event procedure of your form to assign these values.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Philip" <(E-Mail Removed)> wrote in message
news:24D07DB2-60B4-4F7C-A146-(E-Mail Removed)...
> Hi,
>
> I have several tables in an Access 2003 database.
>
> On each one I have 4 columns - 2 for 'created by' user and date and two
> for
> 'amended by' user and date.
>
> How do I populate these columns on Add new or Update row with the NT ID?
>
> thanks for any help.
>
> Philip

Thankyou - I think that's what I need!

Philip

"Allen Browne" wrote:

> Here is the code to get the user name:
> http://www.mvps.org/access/api/api0008.htm
>
> Use the BeforeUpdate event procedure of your form to assign these values.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Philip" <(E-Mail Removed)> wrote in message
> news:24D07DB2-60B4-4F7C-A146-(E-Mail Removed)...
> > Hi,
> >
> > I have several tables in an Access 2003 database.
> >
> > On each one I have 4 columns - 2 for 'created by' user and date and two
> > for
> > 'amended by' user and date.
> >
> > How do I populate these columns on Add new or Update row with the NT ID?
> >
> > thanks for any help.
> >
> > Philip
>
>