How to control menubar


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
 
Ad

Advertisements

J

Jonathan Parminter

-----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
.
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
 
Ad

Advertisements

K

Kate

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top