I've some issues with OLEObjects and recordsets...
I create some controls on the fly in my code. I prepare them, I fill them, and then I use the data collected from them to run a query on an AS400 (adodb).
When I get the data back I've this issue :
my oleobjects
on top of the worksheet start acting weird: they seem normal, but when I click on one of them, the Left
property seems to change. While holding the mouse button down I see the control twice, once where it should be, and at another position offset to the right (let's call it the buggy version). If my pointer leaves the control it returns to its normal position.
The globality of the control reacts to my mouse click for offsetting the control to the right and showing its "Buggy version", but the normal behaviour (Click
is the only event I manage) only happens if I click on the Buggy Version... Each time I run the query the buggy controls are more and more offset to the right.
Here are some pictures :
Start: all is ok
First query: behaviour after the first run when I click on the left part of the button:
Second query: same, but the offset is greater:
When I don't click on the controls they are like in the first picture.
This affects all my controls except the first 3 which are at left = 0
I hope I was clear and that someone has an idea about what is happening.