access 2010 - getting user info using environ()
Posted on 2013-06-20
I'm beginning work on a new database using Access 2010. An idea I had was to record the user's information when a new record was created, or perhaps when it is changed. Anyway, I was considering using Environ("USERNAME") and I've done a bit of research but can't figure out how to implement it so that it populates a field I have reserved for this in my table/form.
I think part of my problem is that I don't know VB.
Could someone assist me with some advice built for a newb? I've seen some code snippets on this, but I don't know where this code needs to go or the best way to trigger it to populate the record...