Jack and Pat
drawbridgej at sympatico.ca
Fri Apr 3 17:06:02 CDT 2009
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