Saving Login Id on each record

[Guest]

I have an access database using vba with sql tables. I want to add a field
that will automatically update with the userid of the person entering the
record. Any suggestions on code and how to retrieve login name.

 

[Roger Carlson]

If you are referring to the network login name, look here:
http://www.mvps.org/access/api/api0008.htm for basic code. On my webite
(www.rogersaccesslibrary.com) I have a small Access database sample called
"AuditTrail.mdb", which uses this process.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

an easy and quick way..... on the "Before Insert" event of the FORM
Me.CREATE_TS = Now()
Me.CREATE_ID = UCase(Environ("USERNAME"))

Of course CREATE_TS and CREATE_ID are fields in the table. I also have A
UPDATE_TS AND UPDATE_ID on the tables which are updated on the "Before
Update" Event of the Form.

 

[Douglas J. Steele]

I always recommend very strongly against using the Environment variable.
It's trivial to reset Environment variables. Go the API route.