[AccessD] Queries Progress Bar

I have to ask, why a "Progress Bar", just give them something to look at
with animation. People get used to not even looking unitil the animation
finishes anyway. IOW they get used to click to open then walking away for a
coffee knowing they have x tseconds/minutes  before it is ready.  Dont break
your butts on a progress bar which is only ever looked at the first few
times.

max
lateral thinking...

On 4/3/09, Hewson, Jim <JHewson at nciinc.com> wrote:
>
> I think it's a great idea.
> I have tried several times to do what you describe - I have never been
> successful.
> What I learned is that any progress bar you make will ultimately be a
> something you have crafted with two labels and code to make progress
> after each process completes.  That means after each query runs...
> I have used the FMS add-in and it does work, but it takes up more
> clock-time to run than it's worth.
> I hope someone can give you help on this.
>
> 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 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
>
>
> ################################################################################
> If you have received this message in error, please contact the sender
> immediately and be aware that the use, copying, or dissemination of
> this information is prohibited. This email transmission contains
> information from NCI Information Systems, Inc. that may be considered
> privileged or confidential and is intended solely for the named
> recipient.
>
> ################################################################################
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>