Staff log-in

[Karafer]

I had this problem...

My database is about recording cash inflows in a dormitel (Dormitory + Hotel,
hehe). All my tables has a field for Staff, to record the staff that was in
charge of inputting a certain information in the database. What I want is to
make it automatic. When they open the database and log-in with their names
and password....I want it in such a way that in any new transaction or
information they will record (for example in booking or in billing), the
username they inputed will be automatically be placed in the staff fields for
that particular transaction.

How will I do that? Is that even possible?

 

[John Smith]

Set the default value of your fields to =CurrentUser() and if you are showing
the field on the form, lock it so that it cannot be changed!

John
##################################
Don't Print - Save trees

 

[Allan Murphy]

Karafer

After the user logs in do they go to a menu or directly to the transaction
form?

On the transaction form you could hide the field for the staff name then in
the default value of staff name
put the following =forms!form name!field name.
form name is the name of your login form
field name is the name of the field where the staff enter their name

Allan

 

[Karafer via AccessMonster.com]

Set the default value of your fields to =CurrentUser() and if you are showing
the field on the form, lock it so that it cannot be changed!

John
##################################
Don't Print - Save trees

I had this problem...
My database is about recording cash inflows in a dormitel (Dormitory + Hotel,

[quoted text clipped - 6 lines]

that particular transaction.
How will I do that? Is that even possible?

Thanks! But Isn't that supposed to input the username that was logged in the
computer itself? And not on the database?

 

[Karafer via AccessMonster.com]

Yeah...I have thought of that but have not yet tried

Well, they get on the welcome page of the switchboard...and they can choose
among the many tabs depending on the transaction they want to record.

Will that input the name of the staff on any transaction they add where there
is a staff field?

Okay..I'll try it thanks!

Karafer

After the user logs in do they go to a menu or directly to the transaction
form?

On the transaction form you could hide the field for the staff name then in
the default value of staff name
put the following =forms!form name!field name.
form name is the name of your login form
field name is the name of the field where the staff enter their name

Allan

I had this problem...

[quoted text clipped - 12 lines]

How will I do that? Is that even possible?

 

[Karafer via AccessMonster.com]

How do you refer to a field placed in the subform of a form which is placed

Karafer

After the user logs in do they go to a menu or directly to the transaction
form?

On the transaction form you could hide the field for the staff name then in
the default value of staff name
put the following =forms!form name!field name.
form name is the name of your login form
field name is the name of the field where the staff enter their name

Allan

I had this problem...

[quoted text clipped - 12 lines]

How will I do that? Is that even possible?

 

[John Smith]

No, it's the other way round. CurrentUser() gives the Access login user.

HTH
John
##################################
Don't Print - Save trees

Set the default value of your fields to =CurrentUser() and if you are showing
the field on the form, lock it so that it cannot be changed!

I had this problem...
My database is about recording cash inflows in a dormitel (Dormitory + Hotel,

[quoted text clipped - 6 lines]

that particular transaction.
How will I do that? Is that even possible?

Thanks! But Isn't that supposed to input the username that was logged in the
computer itself? And not on the database?

 

[Jan Baird]

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.

 

[Jan Baird]

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.

 

[Jan Baird]

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.

 

[Jan Baird]

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.

 

[Jan Baird]

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.

 

[Karafer via AccessMonster.com]

No, it's the other way round. CurrentUser() gives the Access login user.

HTH
John
##################################
Don't Print - Save trees
[quoted text clipped - 7 lines]

Thanks! But Isn't that supposed to input the username that was logged in the
computer itself? And not on the database?

Okay I'll try...