473,406 Members | 2,956 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Progress Bar with an action query.

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
3 2323
PhilOfWalton
1,430 Expert 1GB
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
1,430 Expert 1GB
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, 235 views)
Feb 12 '19 #3
Rabbit
12,516 Expert Mod 8TB
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

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

Similar topics

1
by: WW | last post by:
How can I turn off the Action Query warnings in a VBA code? Thanks
5
by: deko | last post by:
How to run action query against linked table? I have an Access 2003 mdb with an Excel 2003 Workbook as a linked table. When I attempt to run an action query against the linked table I get this...
8
by: thefj | last post by:
Hey all, As part of an access application, I am importing data from an XML file into a table, then using an update query to process the imported data into various other tables in the database...
10
PEB
by: PEB | last post by:
When I try to add by action query the sum of the previous values in the recordset - the sum isn't correct I want table like this named Test: Field1, MySumField Test, 1 Test, 2 Test, 3...
1
by: paullynch | last post by:
Problem running action queries: MS Access On running an access macro with runquery actions that run various action queries which create/delete and replace several tables, I am trying to avoid the...
1
by: ezderek | last post by:
For many years if I wanted to run an action query from code, I've used code something like this --- dim qd as query dim sSQL as string dim db as database set db = currentdb() sSQL = "UPDATE...
2
by: fniles | last post by:
I am using VB.NET 2005 and MS Access. I use OLEDbCommand ExecuteNonQuery to delete a record from a database. Whenever the program gets a message, it creates a new thread to process that message....
2
by: TroutmansRegistrar | last post by:
I have a web programming task that has me stumped. I hope that one of you could give me some insight or might know someone who could guide me in the right direction. This is the final piece of the...
1
rsmccli
by: rsmccli | last post by:
Hello, using Access 2002. I was wondering if someone knows a way to show the results of an append or update query. When you run, let's say, an Append Query, Access notifies you that 10 records...
14
by: sarabonn | last post by:
hallo Iam trying to insert a row into a access database using visual c# and iam getting an error " cannot open the action query". here is my code private void button1_Click(object sender,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.