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
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