PC Review


Reply
Thread Tools Rate Thread

CommandBarButtons not responding

 
 
Dale Fye
Guest
Posts: n/a
 
      27th Nov 2007
The problem seems to go beyond my previous post about the "state" not
changing. Actually, the stat is changing, it is just not being displayed in
the popup menu; and it gets more intriguing. I have two lines of code that
either enable or disable two of my CommandBarButtons based on the value of a
multipage control.

Application.CommandBars.FindControl(Tag:="FilePrintCapability").Enabled =
(intTabNum = 0)
Application.CommandBars.FindControl(Tag:="FilePrintGap").Enabled =
(intTabNum = 1)

These two lines of code should be enabling one button and disabling another,
but are doing nothing. The Enabled property of these buttons is staying as
True regardless of the value of intTabNum.

Any help would be greatly appreciated.

Dale
--

Email address is not valid.
Please reply to newsgroup only.
 
Reply With Quote
 
 
 
 
sebastienm
Guest
Posts: n/a
 
      27th Nov 2007
Hi
Try:
-if you have a 'On Error Resume Next' before setting the Enabled property,
then comment it out and try running again. (could be that the FindCOntrol
doesn't find anything and so the 'Enabled =' would do nothing).
- what is the datatype of intTabNum
- just before and after '...Enabled =', try
debug.print (intTabNum = 0)
debug.print (intTabNum = 1)
--
Regards,
Sébastien
<http://www.ondemandanalysis.com>


"Dale Fye" wrote:

> The problem seems to go beyond my previous post about the "state" not
> changing. Actually, the stat is changing, it is just not being displayed in
> the popup menu; and it gets more intriguing. I have two lines of code that
> either enable or disable two of my CommandBarButtons based on the value of a
> multipage control.
>
> Application.CommandBars.FindControl(Tag:="FilePrintCapability").Enabled =
> (intTabNum = 0)
> Application.CommandBars.FindControl(Tag:="FilePrintGap").Enabled =
> (intTabNum = 1)
>
> These two lines of code should be enabling one button and disabling another,
> but are doing nothing. The Enabled property of these buttons is staying as
> True regardless of the value of intTabNum.
>
> Any help would be greatly appreciated.
>
> Dale
> --
>
> Email address is not valid.
> Please reply to newsgroup only.

 
Reply With Quote
 
Dale Fye
Guest
Posts: n/a
 
      27th Nov 2007
Sebastien,

When I step through my code, and print the value of the Enabled property of
each of these buttons, they are correct, one is enabled, the other disabled,
but when I popup the menu, both items appear and respond as if they are
enabled.

Generally the same issue with changing the state of another button, the
state property of the button displays the correct value when it is printed,
but when the state = msoButtonDown, the button should display a checkbox, and
it doesn't.

I thought that maybe I was creating another copy of a commandbar that
already exists, but confirmed that the commandbars are deleted and recreated
in the initialize event of the form.

Help!!!!!!!!!!!!!!!!!

Dale
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.

"sebastienm" wrote:

> Hi
> Try:
> -if you have a 'On Error Resume Next' before setting the Enabled property,
> then comment it out and try running again. (could be that the FindCOntrol
> doesn't find anything and so the 'Enabled =' would do nothing).
> - what is the datatype of intTabNum
> - just before and after '...Enabled =', try
> debug.print (intTabNum = 0)
> debug.print (intTabNum = 1)
> --
> Regards,
> Sébastien
> <http://www.ondemandanalysis.com>
>
>
> "Dale Fye" wrote:
>
> > The problem seems to go beyond my previous post about the "state" not
> > changing. Actually, the stat is changing, it is just not being displayed in
> > the popup menu; and it gets more intriguing. I have two lines of code that
> > either enable or disable two of my CommandBarButtons based on the value of a
> > multipage control.
> >
> > Application.CommandBars.FindControl(Tag:="FilePrintCapability").Enabled =
> > (intTabNum = 0)
> > Application.CommandBars.FindControl(Tag:="FilePrintGap").Enabled =
> > (intTabNum = 1)
> >
> > These two lines of code should be enabling one button and disabling another,
> > but are doing nothing. The Enabled property of these buttons is staying as
> > True regardless of the value of intTabNum.
> >
> > Any help would be greatly appreciated.
> >
> > Dale
> > --
> >
> > Email address is not valid.
> > Please reply to newsgroup only.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Repost - CommandBarButtons not responding Dale Fye Microsoft Excel Programming 2 29th Nov 2007 06:37 PM
Repost - CommandBarButtons not responding Dale Fye Microsoft Excel Crashes 0 29th Nov 2007 03:50 PM
Repost - CommandBarButtons not responding Dale Fye Microsoft Excel Crashes 0 29th Nov 2007 03:47 PM
Source of bitmaps and masks for CommandBarButtons? robert.waters Microsoft Access Forms 1 1st Feb 2007 05:33 AM
Two CommandBarButtons runs the same code OS538DAV Microsoft Outlook Program Addins 0 18th Jun 2006 09:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:03 PM.