[AccessD] Queries Progress Bar

Well, stamping your feet will only get you sore feet and a clip round the
ear.

I have something up my sleeve (my arm - ha!) but I can't do it now - maybe
next week BUT it is not a progress bar in the sense you mean.

max


On 4/3/09, William Hindman <wdhindman at dejpolsystems.com> wrote:
>
> ...I have considered using an ajax type loading animation from the web but
> REALLY want a progress bar :)
>
> William
>
> --------------------------------------------------
> From: "Max Wanadoo" <max.wanadoo at gmail.com>
> Sent: Friday, April 03, 2009 4:19 PM
>
> To: "Access Developers discussion and problem solving"
>
> <accessd at databaseadvisors.com>
> Subject: Re: [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
> >>
>
> > --
>
> > 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
>