[AccessD] Queries Progress Bar

William Hindman wdhindman at dejpolsystems.com
Mon Apr 6 12:02:13 CDT 2009


...of course I want you to look into it ...do I sound like I'm into creating 
ocx's? ...noooooooooooooooooooo!

William

--------------------------------------------------
From: "Drew Wutka" <DWUTKA at marlow.com>
Sent: Monday, April 06, 2009 11:45 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Queries Progress Bar

> Hey, I didn't build Access you know! ;)
>
> #4 is really your best shot to reach your goal.  It's theoretical
> though.  You'd have to go about it by using SetWindowsHookEx from
> another program.
>
> Let me know if you'd like me to look into it. Otherwise #1 is the
> easiest to do.
>
> Drew
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
> Hindman
> Sent: Monday, April 06, 2009 8:23 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Queries Progress Bar
>
> ...you call these OPTIONS? ...would you rather swallow rat poison or
> Clorox
> eh? :)
> ...tks, its a decent summary of one of Access's limitations that there
> just
> is no decent work around for.
>
> William
>
> --------------------------------------------------
> From: "Drew Wutka" <DWUTKA at marlow.com>
> Sent: Sunday, April 05, 2009 5:13 AM
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Queries Progress Bar
>
>> I'd say you have the following options:
>>
>> #1. Put in an animation (.avi file).  This would have no accuracy at
>> all.
>>
>> Nothing in Access is going to work while a query is running, because
> VBA
>> is single threaded, so when you run the query, no other code in your
>> project will run.
>>
>> #2.  Break the query down into steps you run manually in code, and
> thus
>> can provide status points to display a progress.
>>
>> #3.  Run the query outside of Jet, I believe ADO (or maybe it's
>> something else) will provide a progress.
>>
>> Both 2 and 3 are going to slow things down, because Jet is going to
> run
>> optimized on it's own, these options are going to take longer.
>>
>> #4.  Jet is reporting the progress to the status bar.  In theory, you
>> could create an ActiveX progress bar that would monitor and redisplay
>> the progress from the status bar itself.  That's completely
> theoretical.
>> I haven't looked into the logistics.  The key component would be
> whether
>> the activeX would keep running on it's own, outside of the VBA thread.
>>
>> Drew
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
>> Hindman
>> Sent: Friday, April 03, 2009 2:21 PM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Queries Progress Bar
>>
>> Group
>>
>> ...I have the following in the FormLoad event:
>>
>>    DoCmd.SetWarnings False
>>    tblExhibitorWebClear
>>    DoCmd.OpenQuery "qryExhByShowCurrentAppend"
>>    DoCmd.OpenQuery "qryExhByShowPastAppend"
>>    DoCmd.SetWarnings True
>>
>> ...that all happens in the background
>> ...in the foreground I want to display a progress bar that shows the
>> user
>> the progress during the entire process which can take a couple of
>> minutes.
>> ...don't want to use the vb ocx if possible, but would if necessary.
>> ...don't want to use the progress meter in the status bar
>> ...accuracy isn't necessary ...just a reasonable approximation.
>> ...tried using a timer and labels but the queries always run before
> the
>> timer starts
>> ...any ideas or samples much appreciated
>>
>> William
>>
>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> The information contained in this transmission is intended only for
> the
>> person or entity to which it is addressed and may contain II-VI
>> Proprietary and/or II-VI Business Sensitive material. If you are not
> the
>> intended recipient, please contact the sender immediately and destroy
> the
>> material in its entirety, whether electronic or hard copy. You are
>> notified that any review, retransmission, copying, disclosure,
>> dissemination, or other use of, or taking of any action in reliance
> upon
>> this information by persons or entities other than the intended
> recipient
>> is prohibited.
>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> The information contained in this transmission is intended only for the 
> person or entity to which it is addressed and may contain II-VI 
> Proprietary and/or II-VI Business Sensitive material. If you are not the 
> intended recipient, please contact the sender immediately and destroy the 
> material in its entirety, whether electronic or hard copy. You are 
> notified that any review, retransmission, copying, disclosure, 
> dissemination, or other use of, or taking of any action in reliance upon 
> this information by persons or entities other than the intended recipient 
> is prohibited.
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list