Hi All,
I'm sure many of you already know how this is done, but for any newbies like me who've spent ages searching this forum and loads of threads on other sites stating that it is not possible to disable the office button, this is for you. Apologies if this has already been mentioned in another tip.
Experts (certainly not me), if there's anthing I've done wrong here or if there's a better way to do this, please feel free to correct me.
1) Create a new class in VBA (I called mine Ribbon) with the following function in it:
Public Function DisableRibbon()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Function
Make sure the function name is NOT the same as the class name, otherwise it won't run.
2) Create a new macro as follows:
Action:
RunCode
Function Name:
DisableRibbon()
Make sure you save the macro name as Autoexec, this tells access to run the macro on startup.
That's it !!!
All you have to do now is exit your database and re-open.
Awesome stuff if you're trying to make your database look and feel like it's a program in its own right.
Good Luck.
I'm sure many of you already know how this is done, but for any newbies like me who've spent ages searching this forum and loads of threads on other sites stating that it is not possible to disable the office button, this is for you. Apologies if this has already been mentioned in another tip.
Experts (certainly not me), if there's anthing I've done wrong here or if there's a better way to do this, please feel free to correct me.
1) Create a new class in VBA (I called mine Ribbon) with the following function in it:
Public Function DisableRibbon()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Function
Make sure the function name is NOT the same as the class name, otherwise it won't run.
2) Create a new macro as follows:
Action:
RunCode
Function Name:
DisableRibbon()
Make sure you save the macro name as Autoexec, this tells access to run the macro on startup.
That's it !!!
All you have to do now is exit your database and re-open.
Awesome stuff if you're trying to make your database look and feel like it's a program in its own right.
Good Luck.