Reg:vba code wait till the query is completed.

Dear all,

VBA does not wait until all of the records have downloaded to the destination sheet when there are a lot of records in the source table.
How can I verify that the query below has retrieved every record from the source? Please assist me.

Please Login or Register  to view this content.

Set background query to false

I'm struggling to replicate this issue, when running this code the table in my sheet is identical the one from the Wiki page, with all data present.

Originally Posted by anavarathan

Dear all,

VBA does not wait until all of the records have downloaded to the destination sheet when there are a lot of records in the source table.
How can I verify that the query below has retrieved every record from the source? Please assist me.

Please Login or Register  to view this content.

Still getting that error