PDA

View Full Version : Disabling QAT and Ribbon on Startup - Not working?



Hathman
09-16-2011, 07:48 AM
Hi,

I am using the following line of code in my On Load event of my Main form:
DoCmd.ShowToolbar "Ribbon", acToolbarNo

It works great at hiding the QAT and default Ribbon when i open the form directly. However, when i specify this form as the form to open in Access Options, it doesn't work. Why can i open the form directly and have the same piece of code work but when it opens during startup, it doesn't?

It simply seems to ignore it and i can see the default ribbon. Very strange. Any ideas?

Also - This is an .mdb file with user level security that i am opening in Office 2003, 2007 and 2010 (users have many different Office versions). I can determine which version they have and then apply the right code but first i have to get it to work! :)


Thanks,
Hathman