[AccessD] Queries Progress Bar

...sheesh ...talk about a single minded beast ...even an animation stops 
until the query finishes :(

William

--------------------------------------------------
From: "William Hindman" <wdhindman at dejpolsystems.com>
Sent: Monday, April 06, 2009 9:18 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Queries Progress Bar

> ...thanks Jim, I've put it in my library ...looks like there really is no
> way to progress bar a query without breaking it up into separate smaller
> queries ...so its off to the animation library to see what I can figure 
> out
> there :(
>
> William
>
> --------------------------------------------------
> From: "Jim Dettman" <jimdettman at verizon.net>
> Sent: Saturday, April 04, 2009 10:52 AM
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Queries Progress Bar
>
>> William,
>>
>>  I'm going to send you a progress bar form off line that I wrote.
>>
>>  However unless you run the query asynchronously, which you can only do
>> through an ODBC Direct connection, it's not going to do you much good.
>> With
>> regular JET based queries, they run synchronously and you won't get
>> control
>> back until it's finished.
>>
>>  You'd be better off with an animation as the other's have suggested.
>>
>> Jim.
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William 
>> Hindman
>> Sent: Friday, April 03, 2009 3: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
>>
>> -- 
>> 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
>