Windows Thread, Access: Lost menu bar...part solution. in Technical; I have some databases which I have inherited.
When they open they quite often (99% of the time) do not ...
25th February 2009, 02:09 PM #1
Access: Lost menu bar...part solution.
I have some databases which I have inherited.
When they open they quite often (99% of the time) do not show a menu-bar.
I've found from some searching that I can solve this each time I open the database by :
Open Access then go to the Immediate window (ctrl G). Paste
commandbars("menu bar").Enabled = true in the window and hit "enter". This
restores the Menu Bar!!
However I would like to go one step further and for these databases where it is a problem have this command run as the database opens.
I've tried messing with the Macros, created one called autoexec, which ran at startup but I could nt seem to get the code:
"commandbars("menu bar").Enabled = true" to activate.
Any advice appreciated.
25th February 2009, 06:53 PM #2
Hmmm so is it just on some databases or is it on all databases didn't realise some could turn off the menu, have you opened the database on a different machine etc? only ran into it being disabled by user error before and we just cleared the profile all sorted.
25th February 2009, 07:34 PM #3
what version of access / microsoft office is it ?
I think if you go to view --> options or something like that you can force it to keep the menu bar or something weird like that.
commandbars("menu bar").Enabled = "true"
If you let me know what version I can load windows and have a play.
By kennysarmy in forum How do you do....it?
Last Post: 16th December 2008, 09:30 AM
By hipsdontlie in forum Windows
Last Post: 22nd August 2008, 10:00 PM
By Ric_ in forum Comments and Suggestions
Last Post: 26th March 2008, 12:00 AM
By FN-GM in forum EduGeek Joomla 1.0 Package
Last Post: 12th March 2008, 10:55 PM
By adamyoung in forum How do you do....it?
Last Post: 25th January 2006, 12:45 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)