Disabling certain menu names from a toolbar using code. Access2000 DB

[jimtmelb1]

Hi,

I have created a macro that in turn created a toolbar which I use on some forms of my Access 2000 database.

All this works really well. My issue is the user has options to set some security settings in the database which enables and disables certain forms accordingly.

My problem is I don't know how to disable certain menu names from my toolbar using code.

If possible can somebody show me how to do this. I don't care how this is acheived for example if either disappears from the toolbar or is greyed out and can't be used. Either is okay.

Thanking you in advance.
Jim

 

[Ed2020]

I have a template application that I use as a starter for ten for any new databases I am building. It contains, amongst other things, a generic security system that will probably do what you want.

I'd be happy to provide a copy of this. You are not supposed to post email addresses on this site (it attracts spammers) but if you can think of another way of me getting it to you (do you know of an FTP site we could use) then just let me know.

Ed Metcalfe.

Please do not feed the trolls.....

 

[FancyPrairie]

Try something like this:

CommandBars("NameOfTheCommandBar").Controls("NameOfTheMenuItem").Enabled = False