You use the settings in the "other" tab to accomplish this.
the above means you don't have to write code to switch what menu bar shows
for what form. You can imagine with 3, or 5 forms open, and the user
switching between forms, and the menu bar has to change. This would involve
some VERY complex code to accomplish this.
If you use the settings in the "other" tab of the forms property sheet, then
it takes no code at all!!!
I have a sample here that changes the menus when different forms are opened.
the ms-access interface can easily be changed by using the tools->start-up
options. Using those options allows you to complete hide the ms-access
interface (tool bars, database window etc). Also, using these options means
you
do not have to bother setting up security.
Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.
Check out:
http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm
After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html