How to control menubar

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

My computer is running on WinXP and Access 2002.
Is there any way to make disabled a part of the menubar
by using VBA ?
Actually, I'd like to gray out only "Save" menu in
the "File" menu, when the specific control on a form get
focus
Is it possible ?
If it's possible, how can I do it ?

Thank you !

Kate
 
-----Original Message-----
My computer is running on WinXP and Access 2002.
Is there any way to make disabled a part of the menubar
by using VBA ?
Actually, I'd like to gray out only "Save" menu in
the "File" menu, when the specific control on a form get
focus
Is it possible ?
If it's possible, how can I do it ?

Thank you !

Kate
.
Click to expand...
Hi Kate, I think that you misunderstand what >>File >>Save
actually saves. This menu option saves changes to the form
design; not changes to a record.

A record is saved automatically when focus moves to
another record or the form/table/query is closed.

Luck
Jonathan
 
Hi Jonathan,

Thank you for your post.
I know "save" menu does not mean to changes a record and
means to change its form design.
I just mentioned "save" menu in order to make the
explanation simple.
I'm sorry for misleading you.

So, I have found a solution now.

Application.CommandBars("Menu Bar").Controls(1).Controls
("Save(&S)") = False

Thanks anyway !
Kate
 
Back
Top