I have a combo that display optional action for a listbox on the same form.
A have a toolbar with two bottum that use to select/deselect the items in
the listbox. In some activity, I want to disable these two buttons on the
toolbar. How can I change d property of each toolbar button?

SF

Use the click event or the after update event of the control you want to
trigger the action. In an [Event Procedure] use something like the
following:

Sub MyControl_AfterUpdate()
Me.MyButtonName.Enabled = False
Me.MyOtherButton.Enabled = False
End Sub

Use another event such as the form's current event to set them back to True.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"SF" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a combo that display optional action for a listbox on the same
form.
> A have a toolbar with two bottum that use to select/deselect the items in
> the listbox. In some activity, I want to disable these two buttons on the
> toolbar. How can I change d property of each toolbar button?
>
> SF
>
>

Or in this case

Dim Cbo AS Office.CommandBar 'needs to be added to references ie microsoft
office library

Set Cbo=Access.Commandbars("MyBar")
Cbo("Button1").Enabled=False

Pieter

"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Use the click event or the after update event of the control you want to
> trigger the action. In an [Event Procedure] use something like the
> following:
>
> Sub MyControl_AfterUpdate()
> Me.MyButtonName.Enabled = False
> Me.MyOtherButton.Enabled = False
> End Sub
>
> Use another event such as the form's current event to set them back to
> True.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "SF" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> I have a combo that display optional action for a listbox on the same
> form.
>> A have a toolbar with two bottum that use to select/deselect the items in
>> the listbox. In some activity, I want to disable these two buttons on the
>> toolbar. How can I change d property of each toolbar button?
>>
>> SF
>>
>>
>
>

Or,

Dim Cbo AS object 'doesn't need reference to microsoft office library

Set Cbo=Access.Commandbars("MyBar")
Cbo("Button1").Enabled=False


(david)

"Pieter Wijnen" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Or in this case
>
> Dim Cbo AS Office.CommandBar 'needs to be added to references ie microsoft
> office library
>
> Set Cbo=Access.Commandbars("MyBar")
> Cbo("Button1").Enabled=False
>
> Pieter
>
> "Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Use the click event or the after update event of the control you want to
>> trigger the action. In an [Event Procedure] use something like the
>> following:
>>
>> Sub MyControl_AfterUpdate()
>> Me.MyButtonName.Enabled = False
>> Me.MyOtherButton.Enabled = False
>> End Sub
>>
>> Use another event such as the form's current event to set them back to
>> True.
>> --
>> Arvin Meyer, MCP, MVP
>> Microsoft Access
>> Free Access downloads
>> http://www.datastrat.com
>> http://www.mvps.org/access
>>
>> "SF" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> I have a combo that display optional action for a listbox on the same
>> form.
>>> A have a toolbar with two bottum that use to select/deselect the items
>>> in
>>> the listbox. In some activity, I want to disable these two buttons on
>>> the
>>> toolbar. How can I change d property of each toolbar button?
>>>
>>> SF
>>>
>>>
>>
>>
>
>

Thank for all your useful tips.

SF

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:O7Aqx4$(E-Mail Removed)...
> Or,
>
> Dim Cbo AS object 'doesn't need reference to microsoft office library
>
> Set Cbo=Access.Commandbars("MyBar")
> Cbo("Button1").Enabled=False
>
>
> (david)
>
> "Pieter Wijnen" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Or in this case
>>
>> Dim Cbo AS Office.CommandBar 'needs to be added to references ie
>> microsoft office library
>>
>> Set Cbo=Access.Commandbars("MyBar")
>> Cbo("Button1").Enabled=False
>>
>> Pieter
>>
>> "Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>>> Use the click event or the after update event of the control you want to
>>> trigger the action. In an [Event Procedure] use something like the
>>> following:
>>>
>>> Sub MyControl_AfterUpdate()
>>> Me.MyButtonName.Enabled = False
>>> Me.MyOtherButton.Enabled = False
>>> End Sub
>>>
>>> Use another event such as the form's current event to set them back to
>>> True.
>>> --
>>> Arvin Meyer, MCP, MVP
>>> Microsoft Access
>>> Free Access downloads
>>> http://www.datastrat.com
>>> http://www.mvps.org/access
>>>
>>> "SF" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> I have a combo that display optional action for a listbox on the same
>>> form.
>>>> A have a toolbar with two bottum that use to select/deselect the items
>>>> in
>>>> the listbox. In some activity, I want to disable these two buttons on
>>>> the
>>>> toolbar. How can I change d property of each toolbar button?
>>>>
>>>> SF
>>>>
>>>>
>>>
>>>
>>
>>
>
>