Disable Tabs and Right Click

[stu_c]

hi all
I am looking for a way to the form hide tabs and disable right mouse click on loading a specific form but for the whole database rather than specific forms is this possible to do this via VBA?

 

[MajP]

File- Options - Current Database - Ribbon and Toolbar Options

Not sure what you mean by hide tabs

 

[stu_c]

is there a way to do this in VBA?

File- Options - Current Database - Ribbon and Toolbar Options

Not sure what you mean by hide tabs

 

[jdraw]

stu,
Perhaps you could post a graphic showing a sample of what you want to do referencing what should be hidden and any conditions that apply.

 

[stu_c]

 

[MajP]

Instead of using tabbed forms you can use pop up forms. They do not have tabs. I always use pop up. You can try this on the form property under the Other tab.

 

[theDBguy]

Hi. Just in case this helps, please take a look. Cheers!

Database Startup Properties

A recent question in the forums asked how to set certain options for the Current Database through code. Presumably, the purpose is to restri...

thedbguy.blogspot.com

 

[stu_c]

Thank you so much, massive help!
bit of an odd one mind, I cannot find the option to remove / hide the top ribbon bar even when I look through the options menu?

Hi. Just in case this helps, please take a look. Cheers!

Database Startup Properties

A recent question in the forums asked how to set certain options for the Current Database through code. Presumably, the purpose is to restri...

thedbguy.blogspot.com

 

[theDBguy]

Thank you so much, massive help!
bit of an odd one mind, I cannot find the option to remove / hide the top ribbon bar even when I look through the options menu?

Hi. Not sure what you mean by "hide the top ribbon bar." Did you mean something like this?

DoCmd.ShowToolbar "Ribbon", acToolbarNo