473,409 Members | 1,943 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,409 software developers and data experts.

Progress Bar Moving While Running Query

24
Hello,
can somebody give me an idea on how to make a progressbar or something moving in an excel form while using vba to run a query in access that takes about 9 minutes to complete and excel freezes during the time...

Thanks you very much..
Sep 25 '07 #1
4 6791
cyberdwarf
218 Expert 100+
How are you calling the query from Excel?

Excel would need to retrieve the progress status somehow from Access. This will work if you are starting the process from Access creating an Excel object and then passing status message to Excel.
Sep 25 '07 #2
TSIGOS1
24
hi, thanks for the reply,

I just run a simple query from excel vba. Is there a way for excel to get this progress status from access. or even in access itself. How is it done?
Thanks again
Sep 25 '07 #3
cyberdwarf
218 Expert 100+
You would have to post that question in the Excel forum, I guess

Steve
Sep 25 '07 #4
FishVal
2,653 Expert 2GB
Hello,
can somebody give me an idea on how to make a progressbar or something moving in an excel form while using vba to run a query in access that takes about 9 minutes to complete and excel freezes during the time...

Thanks you very much..
Hi, there.

If you retrieve data to ADODB.Recordset you may use FetchProgress event.
Take a look at this article ADO Events [Advanced Content]
Sep 25 '07 #5

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

Similar topics

8
by: Timothy Smith | last post by:
is it possible to mke a progress bar for queries? say i have a query that will take 20 seconds, i'd like to give some feed back to users on how long this will take.
6
by: Stephen Miller | last post by:
Firstly, sorry for the long post, but I've included a fair bit of sample data. Im doing a comparision of 10yr Bond prices and CPI adjustments, with an 18 week moving average of the CPI. I'm...
3
by: MSW | last post by:
I am trying to give the user some indication of some progress of a query since it takes about 5 hours to run. Is there any way to extract the progress of a query WHILE it is running (or perform...
4
by: Raed Sawalha | last post by:
Dear, I have windows form , the form is using a class to do all tasks needed like this private void btnProcess_Click(object sender, System.EventArgs e) { btnProcess.Enabled = false;...
4
by: aj | last post by:
Alan, you can achieve this by using XMLHttp Async functionality in a javascript file. Create an aspx page in which execute long running SQL query, then do an XMLhttp post to that page from a js...
4
by: Kenneth Keeley | last post by:
Hi, I have a page that uploads files to my server and I wish to display a "Please wait while uploading" page to the user while the file is uploading. I have been able to redirect the user once the...
7
by: Pepi Tonas | last post by:
I have a form that takes some time to load because it has to populate some Data. I was trying to display a form on top of it with an activity bar so that user can see that something's going on. ...
11
by: processoriented | last post by:
Hi, I'm something of a noob at this, but here it is... I have an app that fills a dataset from a SQL database, and then writes the dataset to an xml file. Everything is a SELECT query... I am...
0
by: Nishanthmarathe | last post by:
Hi There!!! I am new to C# world. I am getting huge chunk of data from a 3rd party applications thru SOAP request and updating to my SQL Server. I cant implement Progress bar as there is no way...
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: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
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
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...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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.