[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
>