Bahdur
You can use the CurrentUser method to get the user name and run SQL to add
the name to the table. For example
Function AddUserToTable()
Dim stUser As String, stSQL As String
stUser=CurrentUser
' Add the name to the table tblUsers in the field UserName
stSQL = "INSERT INTO tblUsers (UserName) SELECT " & Chr(34) & stUser &
Chr(34) ";"
DoCmd.RunSQL stSQL
End Function
I haven't tested the function but it should work
Hope this will help you
Liveson
----- Original Message -----
From: "Bahadhur Shah" <[EMAIL PROTECTED]>
To: <Accessdevelopers@yahoogroups.com>
Sent: Saturday, June 25, 2005 9:43 AM
Subject: [AccessDevelopers] user name
>
>
>
> Dear all
>
> Any one tell me how to create in table automatically current user name
>
>
>
>
> Thanks
>
> Bahdur shah
>
>
>
>
>
> - This message has been scanned by the DBBCG virus protection system -
>
>
>
> Please zip all files prior to uploading to Files section.
> Yahoo! Groups Links
>
>
>
>
>
>
>
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
