Users for Access

[Simon]

I have built an access database base for my business ( Shop Ordering
System) we are just about to emply some staff, what I would like to do
is have a user log in that will then store Users Name with any order
that user enters into the system

any one got any good ways of doing this

Thanks

SImon

 

[Daniel Pineault]

Their is no fast and easy way to do this. You need to have a login,
User-Level Security, and then code your form's to add this info to the
recordset. You can pull the user's id using the CurrentUser() but only if
you set ULS. Google 'MS Access User-Level Security' to learn how-to
implement it properly.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Armen Stein]

Their is no fast and easy way to do this. You need to have a login,
User-Level Security, and then code your form's to add this info to the
recordset. You can pull the user's id using the CurrentUser() but only if
you set ULS. Google 'MS Access User-Level Security' to learn how-to
implement it properly.

Or, much simpler, have your employees log into their own Windows
account. Then in the Before Update events on the forms, retrieve
their ID and update a field in the record.

You can get the user name with an Access VBA function like this:

Function WindowsUserName() As String

On Error GoTo Error_Handler

Dim strUserName As String
strUserName = Environ("username")

Exit_Procedure:
WindowsUserName = strUserName
Exit Function

Error_Handler:
strUserName = ""
Resume Exit_Procedure

End Function

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Ger Vos]

Their is no fast and easy way to do this. You need to have a login,
User-Level Security, and then code your form's to add this info to the
recordset. You can pull the user's id using the CurrentUser() but only if
you set ULS. Google 'MS Access User-Level Security' to learn how-to
implement it properly.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.