Disable button on toolbar

[mafhobb]

Hi all,

This has to be simple, but the solution eludes me.

I have a database that works really weel, but I need to do some tweaking to the toolbars to "grey out" the "sort ascending" and "sort descending" icons so that hte users do not mess with those and change how the recoerds display.

There has to be an easy way to disable those two buttons or an alternate way to ensure that the form basically ignores them.

Thanks

mafhobb

 

[motleyjew]

If you go to tools -> startup Unclick All Built in Toolbars. That will completley get rid of it altogether. Also, you can click on the arrow at the end of the tool bar that lets you add or remove buttons.

 

[mafhobb]

If you go to tools -> startup Unclick All Built in Toolbars. That will completley get rid of it altogether. Also, you can click on the arrow at the end of the tool bar that lets you add or remove buttons.
Reply With Quote

Hi Motleyjew.

Thanks for the reply, I thought of the first posibility, but I do need the users to use some of the icons, such as "filter by" and "find", so that is not an option I can use. I also though of the second posibility, but changing the toolbar that way only affects my computer, and since this is on a network, I would have to do the same with every machine, or is there any way to do this from my machine, since I am the only one who has administrator access??

mafhobb

 

[The_Doc_Man]

In the first place you are letting users see queries or tables directly. What you are doing now is the price you pay for being a bit TOO "quick and dirty."

It gets worse.

If there are cases where you want users to see those buttons and other cases where they are not allowed, by not going through a switchboard form you have irrevocably lost control of your application.

The only chance left to you to control those buttons in in code running underneath a startup form that either minimizes itself or exits when it has done its customization. (Minimization means you still have SOME control over some issues - VERY LIMITED control.)

Search this forum for STARTUP forms and SWITCHBOARD forms as ways to regain control over your application. In that environment, you can maintain dynamic control over what icon buttons are available.

 

[mafhobb]

In the first place you are letting users see queries or tables directly. What you are doing now is the price you pay for being a bit TOO "quick and dirty."

It gets worse.

If there are cases where you want users to see those buttons and other cases where they are not allowed, by not going through a switchboard form you have irrevocably lost control of your application.

The only chance left to you to control those buttons in in code running underneath a startup form that either minimizes itself or exits when it has done its customization. (Minimization means you still have SOME control over some issues - VERY LIMITED control.)

Search this forum for STARTUP forms and SWITCHBOARD forms as ways to regain control over your application. In that environment, you can maintain dynamic control over what icon buttons are available.

Hi,

Nobody except for me has direct acces to the tables, queries, reports or any design access at all. Most users only have acces to the forms to enter data. All of this has been dealt with depending on the user's needs through the security/permissons wizards. I do have an initial switchboard that takes you to the correct form so you can enter the data you need to enter and there is no way to mess that up. The problem is that one of those forms is a Hystory subform, and in order to keep everything organized by date (to display it in the screen in a logical manner) I need to do either one of two things, limit the use of the "sort" buttons or find a way so that the subform ignores that button (basically make it so that the initial order stays)

All tables have autonumbers organizing the recors and none of it gets "garbled up" when someone clicks on the "sort" buttons. It is just a "display" problem, not a control problem.

Any other sugegctions?

Thanks

mafhobb

 

[mafhobb]

Completelly disabling the "sort" buttons for everyone in all instances would work too, as long as all users can still use the "find" icon

mafhobb

 

[The_Doc_Man]

If you have a controlling form, then when someone clicks the button that opens up your data entry form, you can disable the sort buttons. When that form exits, you can re-enable them. The key is that something MUST be running that permits code to run. That would be a form, report, or macro. From your description, you have a form. So you are good in that sense.

Look this up in the Access Help files:

Adding and Managing Menu Bars and Menu Items

This gives you hints on the programmatic control of menubar or toolbar items. Read the articles in this section, including the "See Also" references.