Prev: Dinamic Naming in Design Grid or SQL
Next: Query Trouble
From: Dan on 23 Feb 2010 07:04
I am using an append query to add a new line to my table - one of the field
in this table is "Update_Date" and one is "Updated_By".
How via this query I can populated those two fields with the current
date&Time and current username of the user .
Many thanks,
Dan
From: Allen Browne on 23 Feb 2010 07:49
In query design view, type this into a fresh column in the Field row:
Now()
Below that indicate the field you want this value assigned to.

Do a similar thing with:
CurrentUser()
for the other field.

Note that CurrentUser() always returns "Admin" if the database is unsecured.
If you wanted the Windows user, use the GetNetworkUserName() function from
here:
http://allenbrowne.com/ser-53code.html#GetNetworkUserName

--
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.


"Dan" <Dan(a)discussions.microsoft.com> wrote in message
news:1F8F974A-A790-4EAF-9E57-D050700968A6(a)microsoft.com...
> I am using an append query to add a new line to my table - one of the
> field
> in this table is "Update_Date" and one is "Updated_By".
> How via this query I can populated those two fields with the current
> date&Time and current username of the user .
> Many thanks,
> Dan

 | 
Pages: 1
Prev: Dinamic Naming in Design Grid or SQL
Next: Query Trouble