424,279 Members | 1,893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,279 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???
1 Week Ago #1
Share this Question
Share on Google+
3 Replies


PhilOfWalton
Expert 100+
P: 1,424
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
1 Week Ago #2

PhilOfWalton
Expert 100+
P: 1,424
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, 5 views)
1 Week Ago #3

Rabbit
Expert Mod 10K+
P: 12,298
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.
6 Days Ago #4

Post your reply

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