T
Tim_S
Access 2003
I have a sign - in and sign - out database for laptop
equipment that is shared among several users.
I have a field called "CheckedInBy" that only exist in
the History table. (not in any other form or table or
query)
I have on the input form a check box that runs an append
query to dump data from the displayed form (main table)
into the history table. When the person checking in a
laptop they check this box and the query appends the
information displayed on the form to a new record in the
History table, then clears the form for future sign-out.
What I want to accomplish is when a new record is added
to the History table, I want to automatically "Pull-in"
or grab the Current logged on username from the system
variable %username% that windows XP Pro captures.
I have tried to put a function in the Default Value
property for the CheckedInBy field as =environ
("username") but it fails when a new record is added to
the table.
Does anyone know of a way to work with the OS system
variables in Access 2003?
I have a sign - in and sign - out database for laptop
equipment that is shared among several users.
I have a field called "CheckedInBy" that only exist in
the History table. (not in any other form or table or
query)
I have on the input form a check box that runs an append
query to dump data from the displayed form (main table)
into the history table. When the person checking in a
laptop they check this box and the query appends the
information displayed on the form to a new record in the
History table, then clears the form for future sign-out.
What I want to accomplish is when a new record is added
to the History table, I want to automatically "Pull-in"
or grab the Current logged on username from the system
variable %username% that windows XP Pro captures.
I have tried to put a function in the Default Value
property for the CheckedInBy field as =environ
("username") but it fails when a new record is added to
the table.
Does anyone know of a way to work with the OS system
variables in Access 2003?