William Hindman
wdhindman at dejpolsystems.com
Mon Apr 6 12:02:13 CDT 2009
...of course I want you to look into it ...do I sound like I'm into creating ocx's? ...noooooooooooooooooooo! William -------------------------------------------------- From: "Drew Wutka" <DWUTKA at marlow.com> Sent: Monday, April 06, 2009 11:45 AM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Queries Progress Bar > Hey, I didn't build Access you know! ;) > > #4 is really your best shot to reach your goal. It's theoretical > though. You'd have to go about it by using SetWindowsHookEx from > another program. > > Let me know if you'd like me to look into it. Otherwise #1 is the > easiest to do. > > Drew > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William > Hindman > Sent: Monday, April 06, 2009 8:23 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Queries Progress Bar > > ...you call these OPTIONS? ...would you rather swallow rat poison or > Clorox > eh? :) > ...tks, its a decent summary of one of Access's limitations that there > just > is no decent work around for. > > William > > -------------------------------------------------- > From: "Drew Wutka" <DWUTKA at marlow.com> > Sent: Sunday, April 05, 2009 5:13 AM > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Subject: Re: [AccessD] Queries Progress Bar > >> I'd say you have the following options: >> >> #1. Put in an animation (.avi file). This would have no accuracy at >> all. >> >> Nothing in Access is going to work while a query is running, because > VBA >> is single threaded, so when you run the query, no other code in your >> project will run. >> >> #2. Break the query down into steps you run manually in code, and > thus >> can provide status points to display a progress. >> >> #3. Run the query outside of Jet, I believe ADO (or maybe it's >> something else) will provide a progress. >> >> Both 2 and 3 are going to slow things down, because Jet is going to > run >> optimized on it's own, these options are going to take longer. >> >> #4. Jet is reporting the progress to the status bar. In theory, you >> could create an ActiveX progress bar that would monitor and redisplay >> the progress from the status bar itself. That's completely > theoretical. >> I haven't looked into the logistics. The key component would be > whether >> the activeX would keep running on it's own, outside of the VBA thread. >> >> Drew >> >> -----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 >> The information contained in this transmission is intended only for > the >> person or entity to which it is addressed and may contain II-VI >> Proprietary and/or II-VI Business Sensitive material. If you are not > the >> intended recipient, please contact the sender immediately and destroy > the >> material in its entirety, whether electronic or hard copy. You are >> notified that any review, retransmission, copying, disclosure, >> dissemination, or other use of, or taking of any action in reliance > upon >> this information by persons or entities other than the intended > recipient >> is prohibited. >> >> >> -- >> 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 > The information contained in this transmission is intended only for the > person or entity to which it is addressed and may contain II-VI > Proprietary and/or II-VI Business Sensitive material. If you are not the > intended recipient, please contact the sender immediately and destroy the > material in its entirety, whether electronic or hard copy. You are > notified that any review, retransmission, copying, disclosure, > dissemination, or other use of, or taking of any action in reliance upon > this information by persons or entities other than the intended recipient > is prohibited. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >