record tracking access 2000

  • Thread starter Thread starter Georg Wurm
  • Start date Start date
G

Georg Wurm

hello fellows!
So, heres my challenge
im using access 2000. i want to create record creations (user and creation
date/time) in each of my tables of the db. i thaught a smart way woul be to
use an user-defined function fo the user and the built in-function for the
date/time in the dafault value of the field [user] and [creation] in each
table so i wouldnt have to change each form in the db. i thaught: smart
way....access stated: NOT! (no user defined funktions in the default value.

please give me a hint. i don't want to change all my forms!

greetings from austria
georg wurm

ps: sorry about my english.....
 
Georg,

You don't need to resort to a user-defined function...
To get the database user name (if you are using security), use:
=Application.CurrentUser in the default value property of your text box.
Likewise, to get the Windows logon user name use: =Environ("CurrentUser").

HTH,
Nikos
 
I would never rely on Environ() across multiple networks and operating
systems. The API for the network user name at
http://www.mvps.org/access/api/api0008.htm. Regardless, you will have to use
this as the default value in a control on a form.

--
Duane Hookom
MS Access MVP


Nikos Yannacopoulos said:
Georg,

You don't need to resort to a user-defined function...
To get the database user name (if you are using security), use:
=Application.CurrentUser in the default value property of your text box.
Likewise, to get the Windows logon user name use: =Environ("CurrentUser").

HTH,
Nikos

Georg Wurm said:
hello fellows!
So, heres my challenge
im using access 2000. i want to create record creations (user and creation
date/time) in each of my tables of the db. i thaught a smart way woul be to
use an user-defined function fo the user and the built in-function for the
date/time in the dafault value of the field [user] and [creation] in each
table so i wouldnt have to change each form in the db. i thaught: smart
way....access stated: NOT! (no user defined funktions in the default value.

please give me a hint. i don't want to change all my forms!

greetings from austria
georg wurm

ps: sorry about my english.....
Click to expand...
Click to expand...
 
Back
Top