s.dinah
11-07-2018, 06:24 AM
Hi,
So I have created this macro that creates a query table an refreshes it every second. I have 2 button to "connect" and "disconnect".
"Connect" runs the code.
The code runs alright and the query table get refreshed accordingly however the buttons are no longer visible! I tried changing the sleep time an the position of doevents but it does not appear make any difference.
Any ideas as to how I can resolve this issue?
ps is there maybe an alternative to use doevents?
So I have created this macro that creates a query table an refreshes it every second. I have 2 button to "connect" and "disconnect".
"Connect" runs the code.
The code runs alright and the query table get refreshed accordingly however the buttons are no longer visible! I tried changing the sleep time an the position of doevents but it does not appear make any difference.
Any ideas as to how I can resolve this issue?
ps is there maybe an alternative to use doevents?