How to show username automaticaly when a new record is created?

[cos]

I have a task whre the username of Access is to appear automatically in the Author Field, so that later, when re-viewing data, I can easily tell who entered a spesific record, as the file is on the shared drive.

I know that there's some easy way of doing it in excell where a macro can be recorded, but no clue on how to do it in Access :banghead:... any ideas at all?

 

[John Big Booty]

Welcome to the forum.

I think the CurrentUser() function is what you are looking for.

 

[cos]

thanks!!
but how do I save that into the table? =/

 

[John Big Booty]

In the Form's On Current event you could use some code along the lines of;

If  Me.NewRecord Then
     Me.YourUserFieldName = CurrentUser()
End If

 

[cos]

where exactly do I paste this code in to? on the form, do I click "view code" and copy it there?

 

[John Big Booty]

You will need to put it into the Form's On Current event using an Event Procedure

You will need to change the red highlighted portions of the code to match the reality of your DB.

If  Me.NewRecord Then
     Me.[B][COLOR="Red"]YourUserFieldName[/COLOR][/B] = CurrentUser()
End If

 

[cos]

I did as you said, and ths is the error message i get..
p.s. i don't think it likes it...

and when i ange it around a little bit, it says that the "Me." is an "Invalid outside procedure"..

 

[John Big Booty]

That code works as advertised in my Sanbbox DB

Did you copy and paste it into the Visual Basic code window and make the required adjustments. To get to the Code window you need to click on the Ellipsis button at the right hand side of the On Current [Event Procedure].

 

[SteveH2508]

The code provided goes between the Sub Form_Current() and End Sub code stubs.

 

[cos]

In which case i receve another error, and then when i click OK, the "Private Sub Form_Current()" is highlited in yellow.. any ideas on how i can fix this?

 

[John Big Booty]

Please see my comments in Post #6, in which I advised that you would need to change that portion of the code to reflect the reality of your DB

 

[cos]

it seem to work now!! Thank you ever so much!

however i do have another minor issue which i will post seporatly =/

 

[John Big Booty]

Good Work