Hello Everyone,
I have a report that I run which takes quite a while to complete. It runs 3 or 4 queries.
I would like to have some indication of progress being made so the user doesn't think their computer has frozen.
The progress bar that microsoft provides does not suit my needs, as it's very sporadic.
One of my queries is a make-table.
I would like to display the number of rows the query has built thus far on my form (to show the user there is progress).
However, I'm not sure how to do this because I can't figure out how to access the VB code for the query (to imbed my code for the form update).
Also, I don't know how large the table is going to be before-hand.
Any help with this would be greatly appreciated.
Thanks,
Max