A
Arturo
I have a team that each is using a stand-alone version of Access 2003. They
can suspend a session and return to continue the session, or if finished with
the session, they can log off the program. A session must be completed within
the same day. If a session is suspended and the user does not return until
the next day, the program will alert them to this and automatically finish
the session and start a new one for that day.
This activity is tracked within by using certain words and phrases that I
will call “keys.â€
Example 1: Key = “LO†starts a new session.
Example 2: Key = “SUS†suspends the session
Example 3: Key = “IS†means that they are currently in a session.
When the database is opened, the key that it identifies determines where to
take the user. This all works well until someone turns off the computer
without closing the program or uses Ctrl Alt Delete to close the program.
If the program is shut down prematurely and the key is “IS†at the time,
when it is reopened, it will give an error message. Is there a function or a
procedure other than “On Close†that will allow me to reset that key when
this happens?
Thank you.
can suspend a session and return to continue the session, or if finished with
the session, they can log off the program. A session must be completed within
the same day. If a session is suspended and the user does not return until
the next day, the program will alert them to this and automatically finish
the session and start a new one for that day.
This activity is tracked within by using certain words and phrases that I
will call “keys.â€
Example 1: Key = “LO†starts a new session.
Example 2: Key = “SUS†suspends the session
Example 3: Key = “IS†means that they are currently in a session.
When the database is opened, the key that it identifies determines where to
take the user. This all works well until someone turns off the computer
without closing the program or uses Ctrl Alt Delete to close the program.
If the program is shut down prematurely and the key is “IS†at the time,
when it is reopened, it will give an error message. Is there a function or a
procedure other than “On Close†that will allow me to reset that key when
this happens?
Thank you.