By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,850 Members | 1,592 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,850 IT Pros & Developers. It's quick & easy.

Progress Bar with an action query.

P: 1
I have an make table action query that takes 10 to 15 minutes to run and I would like to give the user some idea where they are in the process but for the life of me I can't figure out how. I know I can't create a recordset from an action query but is there some way I could keep track of the records as they are added to the table???
Feb 12 '19 #1
Share this Question
Share on Google+
3 Replies


PhilOfWalton
Expert 100+
P: 1,430
Welcome to Bytes, Mickey.

As far as I know it is not possible to do, however, if instead of using a query, you do the same thing using VBA, we can interface the VBA with a progress bar.

See the demo at
https://bytes.com/topic/access/insig...r-progress-bar

Phil
Feb 12 '19 #2

PhilOfWalton
Expert 100+
P: 1,430
Whoops! the link has vanished to the zip file.

Have re-linked it

Phil
Attached Files
File Type: zip Progress Meter.zip (1.63 MB, 12 views)
Feb 12 '19 #3

Rabbit
Expert Mod 10K+
P: 12,341
The deeper question is what is the purpose of this make table query and what's the current SQL?

It's very rare that a make table query is "needed" and with some SQL tweaks, it may be possible to achieve a similar result in much less time.
Feb 12 '19 #4

Post your reply

Sign in to post your reply or Sign up for a free account.