not all my client(s) machines are using office 2007+ so i usually design access with access 2000 and
upgrade as i go to each machine
last year i found that my custom menubars were not showing on new access 2007 machines so i found
a way of getting them back using the 'current database' properties
this works fine except that the initial forms custom menubar was not showing
This was not a problem because all my databases have a switchboard so have no menu anyway
but the problem was in back of my mind.
today i found out how to get the initial forms menu that i will now share with you
1. create a global function with name eg "gfOpen1st" that has this code added
Forms!myform.menubar = "myformmenu"
('myform' being the initial form and 'myformmenu' the name of that forms menubar)
2. create a macro that has
Action: RunCode
Arguments: gfOpen1st()
(this being the name of the function you have previously created)
save as "autoexec"
(it is essential that this is the name assigned, otherwise it does not run)
3. go into current database properties
ensure the 'Display form' item is your initial form
and then in the Ribbon dropdown list type: "autoexec", (this is essential)
also ensure all the following 3 check boxes are unchecked eg "Allow full menus" etc
close and save and reopen and you should find the initial form has its menu back
Does anyone else have any views on this and if this can be found anywhere in the help file
or on any Microsoft webpage?
upgrade as i go to each machine
last year i found that my custom menubars were not showing on new access 2007 machines so i found
a way of getting them back using the 'current database' properties
this works fine except that the initial forms custom menubar was not showing
This was not a problem because all my databases have a switchboard so have no menu anyway
but the problem was in back of my mind.
today i found out how to get the initial forms menu that i will now share with you
1. create a global function with name eg "gfOpen1st" that has this code added
Forms!myform.menubar = "myformmenu"
('myform' being the initial form and 'myformmenu' the name of that forms menubar)
2. create a macro that has
Action: RunCode
Arguments: gfOpen1st()
(this being the name of the function you have previously created)
save as "autoexec"
(it is essential that this is the name assigned, otherwise it does not run)
3. go into current database properties
ensure the 'Display form' item is your initial form
and then in the Ribbon dropdown list type: "autoexec", (this is essential)
also ensure all the following 3 check boxes are unchecked eg "Allow full menus" etc
close and save and reopen and you should find the initial form has its menu back
Does anyone else have any views on this and if this can be found anywhere in the help file
or on any Microsoft webpage?
