Access custom menus.

[Paradigm]

Two questions that I hope someone can help with please.

Is it possible to grey out menu options on a customised menu?
If so how?

Is it possible to show 2 customised menus one when the application is opened
and one when the form is opened?
If so how?

Thanks
Alec

 

[Albert D.Kallal]

Two questions that I hope someone can help with please.

Is it possible to grey out menu options on a customised menu?
If so how?

Yes..you can in code go

if IsInGroup(CurrentUser,"SuperUser") = true then

CommandBars("myCustomBar").Controls("AdminOptions").
Controls("DeleteInvoice").Visible = True

end if

In the above, the use of visiable would actualy hide the opton. You can
change visiable with enalbed to "grey" out.

The above example also shows how to "traverse" a series of sub-menus. The
first level (myCustomBar) would be across the top, then the option would be
Adminoptions...and in that sub-menu, we turned off the DeleteInvoice
button...

Is it possible to show 2 customised menus one when the application is
opened
and one when the form is opened?
If so how?

Yes, for sure. That is not only possible, but encouraged. Each form will
often have different menus. You simply need to set the menu bar into he
"other" tab.

The options to complete hide and keep people out of the ms-access interface
can easily be done using the tools->start-up options. Using those options
allows you to complete hide the ms-access interface (tool bars, database
window etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

Note in the above example, how the menu bar changes for each form that
loads. You can take look at how this was done in this example...

 

[Paradigm]

Thanks. I am using Access 2K and the greyed out option does not seem to
work.
Alec

 

[Paradigm]

Sorry, got it working now, Thanks
Alec

Thanks. I am using Access 2K and the greyed out option does not seem to
work.
Alec
would

 

[Albert D.Kallal]

Hum, post the one line of code you are using to set the enabled = false....

It should work....even in access 97....

Does the code compile BEFORE you actually try it? (hint: if you code don't
work..try compiling it first).

 

[Paradigm]

Thanks, I have it working well now.
Alec