I have a main Access 2010 form with two subforms, shown in PivotTable and PivotChart views. The form is displayed on a monitoring screen, with nothing else open (forms nor other applications outside Access, so full resources available). Through the Timer event, I'm doing a Requery (and nothing else, except updating a text box showing the last update time) every 20 minutes on both subforms to get the latest data.
That's working fine indeed... but every now and then, the lay-out of both subforms gets messed up and I can't find out why - seems to be some kind of glitch. The attached file shows what that looks like for the PivotTable.
The only way to get the lay-out correct again is to click inside the subform, which is quite undesirable for a monitoring screen which should do its work independently. In the attachment, I've already done this in the PivotChart (you can see the blue line around the plot area to show it has been selected).
Indications:
- It doesn't happen all the time but rather randomly, so I cannot reproduce it
- It always happens to both subforms (Table and Chart) at the same time
- Tried to do a Repaint after the Requery, but no success. Also tried to include SetFocus on both forms after that (to try to simulate the action of clicking into it) but no success neither.
Any suggestions?
That's working fine indeed... but every now and then, the lay-out of both subforms gets messed up and I can't find out why - seems to be some kind of glitch. The attached file shows what that looks like for the PivotTable.
The only way to get the lay-out correct again is to click inside the subform, which is quite undesirable for a monitoring screen which should do its work independently. In the attachment, I've already done this in the PivotChart (you can see the blue line around the plot area to show it has been selected).
Indications:
- It doesn't happen all the time but rather randomly, so I cannot reproduce it
- It always happens to both subforms (Table and Chart) at the same time
- Tried to do a Repaint after the Requery, but no success. Also tried to include SetFocus on both forms after that (to try to simulate the action of clicking into it) but no success neither.
Any suggestions?
Attachments
Last edited:
