If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide ribbon event not working
I'm terrible with VBA so this might be something really simple. In
Access 2007, I have a startup form with this event on load: Private Sub Form_Load() DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide DoCmd.ShowToolbar "Ribbon", acToolbarNo End Sub and this on close: Private Sub Form_Close() DoCmd.SelectObject acTable, , True DoCmd.ShowToolbar "Ribbon", acToolbarYes End Sub I've also tried the first event as on open and there is no apparent difference in functionality. I got the code from searching for ways to hide the ribbon and navigation pane. These codes work perfectly for the navigation pane but don't seem to affect the ribbon at all. I've also tried splitting the first event up between on open and on load (hiding the nav pane on open and the ribbon on load) but that didn't work either. Any ideas on why hiding the ribbon isn't working? I swear I've gotten this to work before, without having to create a custom ribbon or anything, I just can't remember how. |
Thread Tools | |
Display Modes | |
|
|