Hiding Access window

[Coombes1976]

Hi, hoping someone can help.

I have an Split access database that when it opens displays a popup form in full screen (like a stand alone application), I have then used the below code to minimize the access window so this is not in the way.

Private Sub Form_Current()
'Hide Data-Base Window:
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
'...Other Actions...
End Sub

I also use a desktop shortcut which is also set to minimized, and this all works great except for one thing. When a user clicks on the Access icon in the task bar to show the form the Access window also shows and the only way to do anything with it is close the open form. Is there a way to completely hide or prevent the access window from opening in the first place? I initially thought to hide the icon in the task bar but cannot find away to do this.

Any help would be awesome.

Cheers
Jonathan

[ranman256]

are you trying to hide the Access app?
or
hide the objects in access (tables,queries,etc) ?

[Coombes1976]

Sorry I was not very clear, hide the access app. I have achieved this but when users click on the access icon in the task bar the app reappears and the only way to clear it from the screen is to close the forms.

[ranman256]

it have to be visible for users to use it.

[isladogs]

See if my example app helps http://www.mendipdatasystems.co.uk/c...ace/4594365418