Hiding VBA code/tables/modules

tmcrouse

Registered User.
Local time
Today, 00:38
Joined
Jun 12, 2012
Messages
14
If I use the below code, will it hide all the items in the database except the front-end forms?

Code:
CurrentDb.Properties("Startupshowdbwindow") = False

It would be in my load section when the DB opens to the menu form. I want to hide everything but the front-end forms the users are using. My only concern is I am dispersing this front-end where my tables are an ODBC to the Teradata server. So, I am not worried about changes to the tables since they dont have rights to do that. But, I want to have the ability for them to do an ODBC because they will need to when they get their Teradata userID and I don't want them to fiddle around with the queries or the modules that have all the codes.
 
This actually works. Then if I go into options and customize the menu, I can leave the External Data active and end-users can ODBC and don't need to see tables because they only need to use the forms.
 

Users who are viewing this thread

Back
Top Bottom