M
Mudoch
In access 2007 I'm converting an older (2000 format) DB application that made
extensive use of custom menus and toolbars. I got the menus/toolbars
converted to Macro menus ok, but many do not work as they once did. In the
older version macros were used to do the menu work.
Ok here's the details:
I have a master form that has 6 sub-forms and two of the sub-forms
themselves have sub-forms. The data must be presented as a single form for
data entry, the user can "hide" all sub-forms but a specific one. This is
accomplished by the custom menus/toolbars options.
Each menu/toolbar entry, in both old design and new 2007 version, is linked
to a macro that runs code in a module.
In the code the function simply sets each sub-forms visible property to
false and moves up the desired form to the top of the master form leaving
enough of the master form to ID the master information.
The master form, lets call it Master, is shown in two ways, in VBcode:
1) DoCmd.OpenForm "Master"
2) DoCmd.OpenForm "Master", , , SFilter
Now when I open Master using method 1 above everything works as expected,
when I use version 2 the sub-forms never hide aqnd the desired sub-form does
not move up.
Any ideas?
extensive use of custom menus and toolbars. I got the menus/toolbars
converted to Macro menus ok, but many do not work as they once did. In the
older version macros were used to do the menu work.
Ok here's the details:
I have a master form that has 6 sub-forms and two of the sub-forms
themselves have sub-forms. The data must be presented as a single form for
data entry, the user can "hide" all sub-forms but a specific one. This is
accomplished by the custom menus/toolbars options.
Each menu/toolbar entry, in both old design and new 2007 version, is linked
to a macro that runs code in a module.
In the code the function simply sets each sub-forms visible property to
false and moves up the desired form to the top of the master form leaving
enough of the master form to ID the master information.
The master form, lets call it Master, is shown in two ways, in VBcode:
1) DoCmd.OpenForm "Master"
2) DoCmd.OpenForm "Master", , , SFilter
Now when I open Master using method 1 above everything works as expected,
when I use version 2 the sub-forms never hide aqnd the desired sub-form does
not move up.
Any ideas?