I have a log in form as a start up form. I would like the all access objects window to be hidden when log in form pop up ? So the user can not see the tables or queries .
I have a log in form as a start up form. I would like the all access objects window to be hidden when log in form pop up ? So the user can not see the tables or queries .
DoCmd.RunCommand acCmdWindowHide
Go to File - Options - Current Database and uncheck Display Navigation Pane. That will hide all your queries, tables and such from prying eyes. You can get around that by holding down the Shift key when you open the database. You will have to manually open the Log In form if you do this, but it generally keeps the average user from messing with your tables and queries. You can always recheck the box when you are working on the master copy.
if you're going to do that I'd also hide the ribbon bar:
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
in the ON OPEN event of your login form