[AccessD] Queries Progress Bar

...thks but that won't work against a query :(

William

--------------------------------------------------
From: "Jack and Pat" <drawbridgej at sympatico.ca>
Sent: Friday, April 03, 2009 6:06 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Queries Progress Bar

> William,
>
>
>
> Take a look at ProgressbarNoOCX 
> <http://support.microsoft.com/?kbid=304581>
>
>
>
>
>
> -----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:33 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [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
>
>>
>
>
>
> -- 
>
> 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
>