Employees

[Guest]

I have a secured database in which each employee must login to have access. I
am wondering if there is a way so that when the employee goes to order
another item it will automatically enter their name into the the "Ordered by"
Employee name field?

Thanks

 

[Al Campagna]

Jenn,
EmployeeName = [CurrentUser]
should do it.

 

[John Vinson]

Jenn,
EmployeeName = [CurrentUser]
should do it.

Al, shouldn't that be

EmployeeName = CurrentUser()

using the builtin function?

John W. Vinson[MVP]

 

[Al Campagna]

Right you are. Thanks for picking that up.
I was thinking of a ControlSource... = [CurrentUser]
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Jenn,
EmployeeName = [CurrentUser]
should do it.

Al, shouldn't that be

EmployeeName = CurrentUser()

using the builtin function?

John W. Vinson[MVP]

 

[Guest]

Thank you for your help, just two more questions though. Do I put that in the
form? And what heading do I put it under

Jenn,
EmployeeName = [CurrentUser]
should do it.

Al, shouldn't that be

EmployeeName = CurrentUser()

using the builtin function?

John W. Vinson[MVP]

 

[John Vinson]

Thank you for your help, just two more questions though. Do I put that in the
form? And what heading do I put it under

I'd put it in the DefaultValue property of the form textbox into which
you wish the employee name to be entered.

John W. Vinson[MVP]

 

[Al Campagna]

That's even a better idea...
Al Camp

I'd put it in the DefaultValue property of the form textbox into which
you wish the employee name to be entered.

John W. Vinson[MVP]

 

[Guest]

That doesn't seem to work either it doesn't fill in the name. Maybe I just
dont have something set up right. Currently it is pulling the mane from a
able that i created not from the secured list that the login comes from could
that have something to do with it, does my employee name have to come from
that list?

 

[Al Campagna]

Jenn,
Yes... [CurrentUser] refers to Microsoft WorkGroup security. If you sign in via
that... Access then knows the CurrentUser, and that can be used in the application.
Although, I'm a bit surprised that you didn't get "Admin" as the value for CurrentUser.
If there is no MS security attached to the app, it should default to Admin.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Al Campagna]

Jenn,
If you have your Names and IDs in a table, you should be able to assign the Users Name
to a Global Variable at sign in time (however you get the Name), and that would be
available throughout the app... during that session.
Here's a starting place for working with Globals...
http://www.blueclaw-db.com/access_database_global_variable.htm

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions