Menubar

[jottiwell]

Hi,

I have a large database with 100+ forms. It originally ran with a menubar at the top, long since forgotten, the menubar name was in the 'menu bar' property of the forms.

1) If I delete the menu bar, the system throws errors ( obviously )

2) I want to replace the menubar with a different one, and I want to change the name of the menubar, I therefore want to ensure that the original menubar name is removed from EVERY form in the database and replaced with the new one.

I could open every form in design view, change the property and then shut it, but that'll take ages + I'd like to know some way of dynamically doing this in the future. I was wondering whether anybody new a way of altering the menubar's on mass, without opening the form first?. I know I can use the

Dim frm as form
For each frm in forms
'set menubar name
next

but this only works on the open forms, I can't open all the forms at once as many have prerequesite conditions which would fail.

Any ideas or shall I open the whole lot in design view :(

Thanks