Default Value... Many Users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

This form is used by many users (about 30 users/day), many times a day
(about 40 times/day). One of the field is called "Employee nbr". For every
utilisation, the user has to retype his employee nbr. (Each user has a
different employee nbr)

Is there a way of making so that each user does not have to re-write the
same thing "employee nbr" 40 times per day?

Thank you for your help!
Karine
 
In the Autoexec macro open a form for the employee to enter their "Employee
nbr". Then for every place they would need to enter "Employee nbr" use --
[Forms]![YourLogonForm]![LogonTextBox]
 
I am a beginner in Access...
I understand what you mean, not sure how to execute that Autoexec macro ?
Thanks

KARL DEWEY said:
In the Autoexec macro open a form for the employee to enter their "Employee
nbr". Then for every place they would need to enter "Employee nbr" use --
[Forms]![YourLogonForm]![LogonTextBox]


Karine said:
Hi,

This form is used by many users (about 30 users/day), many times a day
(about 40 times/day). One of the field is called "Employee nbr". For every
utilisation, the user has to retype his employee nbr. (Each user has a
different employee nbr)

Is there a way of making so that each user does not have to re-write the
same thing "employee nbr" 40 times per day?

Thank you for your help!
Karine
Click to expand...
Click to expand...
 
An Autoexec macro atuomatically executes when ab Access database is opened.

The avoid it from executing you can hold down the shift key all the time the
database is opening.


Karine said:
I am a beginner in Access...
I understand what you mean, not sure how to execute that Autoexec macro ?
Thanks

KARL DEWEY said:
In the Autoexec macro open a form for the employee to enter their "Employee
nbr". Then for every place they would need to enter "Employee nbr" use --
[Forms]![YourLogonForm]![LogonTextBox]


Karine said:
Hi,

This form is used by many users (about 30 users/day), many times a day
(about 40 times/day). One of the field is called "Employee nbr". For every
utilisation, the user has to retype his employee nbr. (Each user has a
different employee nbr)

Is there a way of making so that each user does not have to re-write the
same thing "employee nbr" 40 times per day?

Thank you for your help!
Karine
Click to expand...
Click to expand...
Click to expand...
 
Back
Top