Format Filters

sdk development
1

Hi,

Is there any way to have the Format\Filters option into the toolbar, not as a menu option? I mean, as an icon

Thanks,

Schuster :united_arab_emirates: (BOB member since 2002-08-29)

2

Hi,

I haven’t seen a parameter than can offer this.

But perhaps with a macro (.rea) , you can do this.

monoludo :fr: (BOB member since 2004-07-30)

3

yes, I was thinking in something like that, but how could I add an icon for that specific option to the standard toolbar for instance?

Schuster :united_arab_emirates: (BOB member since 2002-08-29)

4

There are several utilities in BOB’s Downloads that customize toolbars.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

5

Yes, but the samples are always using VBA macros, I cannot find how to apply to the “onaction” the execution of an option from BO menu, like “Format\Filters…”; how can I call that menu option?

Schuster :united_arab_emirates: (BOB member since 2002-08-29)

6

I just want to make sure we are not overlooking the obvious here. You are speaking specifically about adding a Format\Filters icon different from the “Insert Filter” little yellow icon available on the “Report Toolbar” - Yes?

jswoboda :us: (BOB member since 2002-06-20)

7

yes, it is a different icon, the idea is to access directly to that menu option, Format\Filters… but I don’t know how to call it

Schuster :united_arab_emirates: (BOB member since 2002-08-29)

8

Correct, the only way I know of to customize toolbars is using VBA.

Additionally, any menu item can be simulated by using the .Execute method for a command bar control.

Application.CmdBars(2).Controls("F&ormat").Controls("Fil&ters...").Execute

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

9

Thanks! it works :smiley:

Schuster :united_arab_emirates: (BOB member since 2002-08-29)

10

You’re quite welcome. I’m going to move this to the SDK forum, but leave the topic in Reporter as well.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)