Remove hidden form from taskbar

[Guest]

Hi
Is there a way to make sure the hidden form which I am using for log report
is not visible on the task bar to make sure no-one closes the form.

Thanks
Noemi

 

[Arvin Meyer [MVP]]

Prefix the form name with the letters Usys

 

[Linq Adams via AccessMonster.com]

Just be aware that doing this means your form will also be "invisible" in the
Objects Dialog Forms section, unless you set your db to Show System Objects

Goto Tools - Options - View

and check

Show System Objects

 

[Guest]

Hi Arvin
I have tried but I still get the hidden form shown on the task bar but with
the Usys infront of the name.

Have I done somehting wrong.

Thanks
Noemi

 

[Arvin Meyer [MVP]]

You must not be hiding the form UsysMyForm. Maybe, I'm not getting what you
mean by "Task bar". You do mean the Windows Task bar, as there's nothing in
Access with that name. There is a Task Pane but that does not show objects.
The Windows taskbar does not show hidden objects, with or without the prefix
Usys. You can also turn off the Objects in Taskbar option. in Access by
using Tools >>> Options >>> View. Or with the following code as part of the
Open procedure of your hidden form:

Sub Form_Open(Cancel As Integer)
Application.SetOption "ShowWindowsInTaskbar", False
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Guest]

Hi Arvin
I think we might be thinking of different things.
When I say task bar I mean the section on the bottom of the screen which
shows all applications which are open included each individual form that is
opened in Access.

It is the section that also has the Start button.

Thanks
Noemi

 

[Arvin Meyer [MVP]]

Yes that is the Windows taskbar. You can turn off showing Access forms in
the Windows Taskbar:

Tools >>> Options >>> View
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com