Run form invisibly in background

[RipperT]

Is there a way to have a form open but invisible to the user? I am running a
couple of forms that contain code that gently logs users off the app after 5
mins and it requires a form to be open to check a table field every 5 mins
(Can't remember where I got the code, but it works well). How can I keep
this form open but invisible to the user? Further, I've noticed on XP
machines, forms get their own spot on the taskbar. Any way to hide this?

Many thanx,

Rip

 

[Rick Brandt]

Is there a way to have a form open but invisible to the user? I am

running a couple of forms that contain code that gently logs users
off the app after 5 mins and it requires a form to be open to check a
table field every 5 mins (Can't remember where I got the code, but it
works well). How can I keep this form open but invisible to the user?
Further, I've noticed on XP machines, forms get their own spot on the
taskbar. Any way to hide this?

Many thanx,

Rip

In the Open event of the form...

Me.Visible = False

The taskbar issue is from the newer versions of Access, not Windows. The
option to change is called "Windows in Taskbar".

 

[Dirk Goldgar]

In the Open event of the form...

Me.Visible = False

The taskbar issue is from the newer versions of Access, not Windows.
The option to change is called "Windows in Taskbar".

Also if you're opening the form with VBA code, you can open it hidden
without using code in its Open event:

DoCmd.OpenForm, "YourForm", WindowMode:=acHidden

And if the form is hidden, it won't have a button on the task bar, so
you don't have to worry about that.