how to get user id in access query

[adnancanada]

I wonder how to get user id in access query I am using in field. I am pulling some info but I want to add field who pulled this info as username



User: Environ ( "UserName") but not working.


I have another question how to generate serial number in access query when we pull data. I mean can it show row number 1,2,3,4.................

[orange]

There are no row numbers in Access. If you want to put some record sequence on the results of a query or recordset, you could do that.

For your user issue

Create a function as below

Function getuser() As String
 getuser = Environ("username")
End Function

Then in your query use (best guess)

SELECT getuser() AS [User] FROM yourtableNameGoesHere; or in the query wizard User: GetUser()

[adnancanada]

There are no row numbers in Access. If you want to put some record sequence on the results of a query or recordset, you could do that.

For your user issue

Create a function as below

Function getuser() As String
 getuser = Environ("username")
End Function

Then in your query use (best guess)

SELECT getuser() AS [User] FROM yourtableNameGoesHere; or in the query wizard User: GetUser()

Thanks for reply where should I write this code. Should I create form first ? how can I add this value in my result ? Kindly explain? I am not expert in access

[orange]

Create a standard module

copy and paste the function into the module
when saving the module, name it anything but getUser.
It will probably default to module1, just accept that.

Then for your query for testing - in the SQL View, type
SELECT getuser() AS [User] FROM yourtableNameGoesHere;

[adnancanada]

Create a standard module

copy and paste the function into the module
when saving the module, name it anything but getUser.
It will probably default to module1, just accept that.

Then for your query for testing - in the SQL View, type
SELECT getuser() AS [User] FROM yourtableNameGoesHere;

My module1 I just saved would be my table ? what will be table name ?

[rpeare]

I think you're getting mixed up in orange's suggestion, the function he mentions is independent of the table

SELECT [YOURTABLENAMEGOESHERE.]*, getuser() as CurrentUser
FROM [YOURTABLENAMEGOESHERE]

orange's example is just that, an example, you'd get the same user for every record in your source table, if you want to actually show records associated with that table you'd have to add them to your SQL statement.

[adnancanada]

I think you're getting mixed up in orange's suggestion, the function he mentions is independent of the table

SELECT [YOURTABLENAMEGOESHERE.]*, getuser() as CurrentUser
FROM [YOURTABLENAMEGOESHERE]

orange's example is just that, an example, you'd get the same user for every record in your source table, if you want to actually show records associated with that table you'd have to add them to your SQL statement.

oh I got it . It works. Thank you very much you and orange, you guys are awesome!