Hiding forms from users

[JoshuaAnthony]

Hi,

I have a "Main Page" form which opens up due to my "Autoexec" macro. Then every time I open another form from here, the form opens but doesn't have an extra icon on the windows startup toolbar associated with it (hope that makes sense!). THis is great. It is exactly what I want. The problem is that I recently added a form to see who is logged in (so I want that form open all the time but out of view from the user) so added that to the "Autoexec" macro (I've also tried doing it in the "OnLoad" event of "Main Page") but for some reason there is now an icon on my windows task bar for both the "Main Page" AND the "User Look-up" form. I don't want the user to even know about the "User Look-up" form. ANybody know why this has suddenly started occurring for this form and none of the others and how to eradicate this problem?

Thanks,

Joshua

 

[ghudson]

Why do you need the "user" form open all the time? Why not open it only when you need to see it? You can add a simple password to a command button that will prevent the joe blows from opening your user form. Search this forum for the key word "password" and the user name "ghudson" to find the code I have posted to password protect a command button with a simple input box.

You should hide all the default toolbars and menu bars to prevent the user from accessing the inside of your db. Check this thread out... Hide all Access Toolbars and Menubars

 

[JoshuaAnthony]

Hi Ghudson,

I've actually hidden all tool and menu bars. The icon for the "User Look-up" form is showing up on the Windows taskbar along with a separate icon for my "Main" form. It is only occurring with this new form that I have added and is not an issue with any of my other forms for some reason so I figure it must be either some property that I am not setting or else something to do with the method in which I open the form (it occurs even if I open it as a "hidden" form in the Autoexec macro).

I prefer to keep the Main page open at all times if possible. For all forms from the main page I just make them modal popups so that I can keep the Main page open but not accessible. I like to keep it open because my Main page is actually a search results page and the way I have set it up (would prefer not to have to change it now), I don't have to keep any records of which search options I have selected (on a different form) and can just requery the main page at set time intervals.

Thanks,

Joshua

 

[JoshuaAnthony]

Ok simple answer. Somebody in another forum pointed it out:

"Go to Tools->Options, then the View tab and unselect 'Windows in Tasbar'"

Thanks for your help Ghudson. Sorry I didn't explain myself properly!

Joshua

 

[Oldsoftboss]

The code to do this: (A2000)

Application.SetOption "ShowWindowsinTaskbar", False

I use this in the load event of a splash form, just to be sure the taskbar is hidden.

Dave