Logout or Exit access

  • Thread starter luis_a_roman via AccessMonster.com
  • Start date
L

luis_a_roman via AccessMonster.com

Is there anyway to execute an access macro if the access database, forms,
reports etc. does not have any activity to execute an exit macro to quit
access?

I have an access database that I would like to add logout or exit from access
if there is not activity for at least 15 minutes.

Any suggestions on how to code this type of routine in VBA.

Guidance will be helpfull.

Luis
 
L

luis_a_roman via AccessMonster.com

Douglas thank you for the information. Last question, do I need to set up the
procedure as part of the autoexec? More specifically, need to know how the
form is triggered to ensure log off.

Please advise. Thank you again.

Luis
http://msdn2.microsoft.com/en-us/library/bb243861.aspx

Don't worry if you're not using Access 2007: it works the same in all
versions of Access.
Is there anyway to execute an access macro if the access database, forms,
reports etc. does not have any activity to execute an exit macro to quit
[quoted text clipped - 9 lines]
 
L

luis_a_roman via AccessMonster.com

Douglas thank you for the information. Last question, do I need to set up the
procedure as part of the autoexec? More specifically, need to know how the
form is triggered to ensure log off.

Please advise. Thank you again.

Luis
http://msdn2.microsoft.com/en-us/library/bb243861.aspx

Don't worry if you're not using Access 2007: it works the same in all
versions of Access.
Is there anyway to execute an access macro if the access database, forms,
reports etc. does not have any activity to execute an exit macro to quit
[quoted text clipped - 9 lines]
 
L

luis_a_roman via AccessMonster.com

Douglas thank you for the information. Last question, do I need to set up the
procedure as part of the autoexec? More specifically, need to know how the
form is triggered to ensure log off.

Please advise. Thank you again.

Luis
http://msdn2.microsoft.com/en-us/library/bb243861.aspx

Don't worry if you're not using Access 2007: it works the same in all
versions of Access.
Is there anyway to execute an access macro if the access database, forms,
reports etc. does not have any activity to execute an exit macro to quit
[quoted text clipped - 9 lines]
 
D

Douglas J. Steele

Either the AutoExec, or set it as the Startup Form (and have it open another
form if appropriate)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


luis_a_roman via AccessMonster.com said:
Douglas thank you for the information. Last question, do I need to set up
the
procedure as part of the autoexec? More specifically, need to know how the
form is triggered to ensure log off.

Please advise. Thank you again.

Luis
http://msdn2.microsoft.com/en-us/library/bb243861.aspx

Don't worry if you're not using Access 2007: it works the same in all
versions of Access.
Is there anyway to execute an access macro if the access database,
forms,
reports etc. does not have any activity to execute an exit macro to quit
[quoted text clipped - 9 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top