auto close?

[kwtmd]

My staff frequently does not close out the access database which prevents me from opening it exclusively to modify it. is there a way to automatically close the database after a period of inactivity? thanks

 

[pbaldy]

Several; I use this:

http://www.peterssoftware.com/isd.htm

 

[maxmangion]

if you search this forum, someone has posted an example which will logout users automatically after 30 seconds.

 

[kwtmd]

thanks

thanks for your help

 

[kwtmd]

close order

I used the petersoftware - excellent... thanks. The one problem I encountered was if someone was working on a record adding information and then left it alone, when the auto close went into effect the sequence of closing caused a problem. There was no related record to attach it to, so the form would not close. Is there a way to sequence the closure of the forms?

 

[pbaldy]

You could certainly modify the code to do that. In the Select/Case statement that would close Access, you can add whatever code is required to gracefully exit your application. I'm not clear on the problem, but perhaps that's enough to get you going?

 

[kwtmd]

fixed

It was an error in my coding. I simply had the field to update OnChange as opposed to OnAfterUpdate.

Is there a way, such that the initial form does not show the warning when the program starts ie "shut down in few moments" and only show when the time has elapsed?

 

[Accessme2]

It probably would be a good idea if you put and undo before you close the form. just a thought.

 

[pbaldy]

The instructions include this, which should hide it until the appropriate time:

5. Put the following line of code in your startup procedure, or in your switchboard form OnOpen event procedure:

DoCmd.OpenForm "frmInactiveShutDown", , , , , acHidden

 

[kwtmd]

the form is still present. Does not go "invisible"....

 

[pbaldy]

That works fine for me, even if the form is already open. Double check the spelling of the form name and that the adHidden is in the correct spot, in case you have a different version of Access.

If you still have trouble, can you post a sample?