Access hidden forms (1 Viewer)

Reeses

Registered User.
Local time
Today, 11:44
Joined
Oct 29, 2019
Messages
17
Hey all,
I am stuck. Thanks to alot of research and YouTube, I finally was able to create a DectectIdleTime for one of my databases. My coworkers have a habit of leaving the database open all the time and even overnight and it was causing issues. So I needed a way to be able to have it auto close after a certain amount of idle time. Now I am stuck on how can I "hide" the DetectIdleTime form but still keep it running in the background? Right now it only works if u have it open and I can guarantee my coworkers will not open it. I read there are ways but I'm not understanding them. Can someone please go into specifics or step by step on what I need to do? Any help is appreciated. Thank you.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:44
Joined
Aug 30, 2003
Messages
36,118
In the load event of whatever form you have opening with the app:

DoCmd.OpenForm "YourFormName", acNormal, "", "", , acHidden
 

Reeses

Registered User.
Local time
Today, 11:44
Joined
Oct 29, 2019
Messages
17
Thank you so much! Worked like a charm. I appreciate your help and the specific instructions.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 11:44
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

Users who are viewing this thread

Top Bottom