Show/Hide button stops working unexpectedly

[tfurnivall]

I have a form with a button (cmdVendorSelectSystem) that toggles a list from a list of Vendors to a list of Systems.

During testing I kept the initial state of the .Visible property to true. The button worked as intended - the list switched its contents, and the caption changed from "Select Systems" to "Hide Systems".

Then, once I was happy with the working, I changed the default setting to False (ie hidden). Now, whenever I select a Vendor from the list, I want to set the state of the Visible property to true, so that the button can operate the way I want it to (it makes no sense to keep it visible unless a Vendor is being displayed). However, the code does not produce the right result, ie the button does not appear, even though the control itself reports the state of the Visible property as True! Reality does not agree with the state of the control for some reason.

If I keep it visible all the time, then it works as it is supposed to. It's only when I try and make the button come into view that it fails.

Any ideas?


Tony

PS In a try-anything-once mood I clicked on the place where the invisible button is located. mirabile dictu it worked! Even though nothing was visible, the list changed, and the button became visible once I changed the caption (see code below). I'll post this as an interim question, just in case anyone has any quick solutions, and I'll post back as I learn more.

Here's the code to load a vendor and make the button visible:

Please Login or Register  to view this content.

and here's the code that 'does the work'.

Please Login or Register  to view this content.

[Winon]

Hello tfurnivall,

Please could you attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.


Regards.

[tfurnivall]

Every time I try and reply I get a message saying that I have been blocked by some sort of firewall software. Any ideas?

[tfurnivall]

Sucuri WebSite Firewall - CloudProxy - Access Denied

Is what I get. I tried without the attachment, but it seems still to be larger than some (uniknown?) limit.

I'll try breaking my response down into shorter segments.

Tony

[tfurnivall]

Here is the .xlsm file. (Not actually - see above)

Because it's still (very much) in development, you'll need to do the following:

1) Run the .xlsm file
2) Alt+F11 to get to the VBE
3) Open form PMSForm and use F5 to run it
4) Select the Vendors/Suppliers tab on the multi-page control
5) Click on one of the Vendors in the list.
6) Exit will take you out of the form, and back to the VBE

WHAT SHOULD HAPPEN

a) Vendor is loaded into the form fields on the tab
b) Two buttons appear: Select Systems, and Show Competencies

a) works, but b) doesn't.

[tfurnivall]

One fascinating thing -if you click at the point where either of those buttons is located (check the uncompiled form to find out), then the button will appear, and it will process the click properly! (Under the State textbox, and under the PostCode textbox)

If you look at the procedure Sub LoadVendorIntoFormFIelds, in the code page of the form, you will see that I have commented out code to HIDE each of the buttons, explicitly. If this code is UNcommented, then b) will also work.

Thanks for your assistance,

Tony

[tfurnivall]

I think I have it - at one point I had anglebrackets around a comment. I think that the firewall tried to interpret this as malicious HTML code.
Note the absence of such characters now!

Here's the attachment,

Tony

[tfurnivall]

A little update to take away the sour taste of recent news.

The behavior is copyable (when I copy the button to a different page in the mp control, then it also exhibits the same behavior. This makes me wonder if it is a corrupt version of code for buttons. Also, my work-around (hide the button then make it visible) works fine as long as I don't select the first entry in the list (ie ListIndex=0). This could indicate that a piece of code testing for ListIndex>0 is having some unexplained effect.

This started as a minor annoyance, but now I'm getting really puzzled - I suppose what I should do is create a lab environment for it. I'll post back any results from that.In the meantime, if anyone has any ideas, I'd love to hear them!

Tony

[Winon]

Hello tfurnivall,

I must be honest. I have totally lost track of what I did where in your Code, but please see if you could make do with the attached sample Workbook.

Regards.

[tfurnivall]

Hi Winon,

Thanks for your efforts, however, they seem to have been fruitless! The buttons don't appear when they 'should', although if I click where they are despite being invisible, then they work.

I'm really beginning to think that this is a bug. A real live bug, although I'm darned if I know how to preciptate it at will.

Tony

[Winon]

Hi tfurnivall,

After Posting the Workbook, I also found my attempts to be fruitless.

Hopefully I have it now sorted out, and would like to hear your feedback on the new revised attached Workbook.

Regards.

[tfurnivall]

Seems still to have a problem. The canonical test is:
1) Select Vendors (list of vendors seen)
2) Select any (I choose 1st, 2nd, 3rd, 5th and 8th) vendor
3) Vendor data will appear in the text fields, AND two buttons will appear (This is where your version fails)

Side-note - if you click where the buttons are meant to be, even though they are invisible, they will click into view! Go figure

Tony