B
Bonnie
Hi there everyone! Using A02 on XP. Not a programmer, but learning great
things here.
I have a table ('LogTable' with fields [Who], [What], [When] and [Where]) in
my backend DB linked to my front ends. Best I could create myself was to make
2 append queries (qLogIn and qLogOut) with [Who]=CurrentUser(), [What]='In'
or 'Out', [When]=Now(), [Where]='DB name' that run OnOpen and OnClose on my
AutoExec form (shift key disabled) in each frontend. (I have to key DB name
in queries during initial setup.)
Works great. BUT...of course there's a but, a few DB's allow the shift key
bypass when opening so the autoexec form does not open, ergo, no records
appended.
I know there is a better way. Would like to create a record when the DB is
opened and closed so it doesn't depend on a form opening. Do I create a
module?
Thanks in advance for any advice or help. Luv U guys!!!
things here.
I have a table ('LogTable' with fields [Who], [What], [When] and [Where]) in
my backend DB linked to my front ends. Best I could create myself was to make
2 append queries (qLogIn and qLogOut) with [Who]=CurrentUser(), [What]='In'
or 'Out', [When]=Now(), [Where]='DB name' that run OnOpen and OnClose on my
AutoExec form (shift key disabled) in each frontend. (I have to key DB name
in queries during initial setup.)
Works great. BUT...of course there's a but, a few DB's allow the shift key
bypass when opening so the autoexec form does not open, ergo, no records
appended.
I know there is a better way. Would like to create a record when the DB is
opened and closed so it doesn't depend on a form opening. Do I create a
module?
Thanks in advance for any advice or help. Luv U guys!!!