Re: Staff log-in

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" <u43776@uwe> wrote in message news:849048330ad95@xxxxxx
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?



.

Relevant Pages

  • Staff log-in
    ... My database is about recording cash inflows in a dormitel (Dormitory + Hotel, ... All my tables has a field for Staff, to record the staff that was in ... that particular transaction. ...
    (microsoft.public.access.formscoding)
  • Re: Staff log-in
    ... My database is about recording cash inflows in a dormitel (Dormitory + Hotel, ... All my tables has a field for Staff, to record the staff that was in ... that particular transaction. ...
    (microsoft.public.access.formscoding)
  • Re: Staff log-in
    ... 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 ... form name is the name of your login form ...
    (microsoft.public.access.formscoding)
  • Add a record in VBA
    ... I have a form that has a combination of several unbound fields: Staff Name, ... a transaction table with equivalent fields in it. ... I am looking for help in writing an add record code to put the unbound data ...
    (microsoft.public.access.forms)
  • Re: Application logic and Business logic
    ... >> Staff may return a set of employees ... It is not array, it is an ADT with has array interface. ... > employees living in a given city, ... Context: Transaction; ...
    (comp.object)