[AccessD] Queries Progress Bar

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