Drew Wutka
DWUTKA at Marlow.com
Mon Apr 6 16:59:56 CDT 2009
Ok William, looked into it a little further. There's a catch. You can hook into another window's events, just not in VB, you have to use a .dll....a C++ .dll, to capture the event procedure. I'm not that great with C++, have too much on my plate to dig into all of that right now. Haven't installed C++ in years. If anyone has the time/inclination to do so, using a SetWindowsHookEx API call, for a child window of Access using the OStatProg class, you should be able to find the events that Jet is sending to that window and run your own progress bar off of them. 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 12:02 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Queries Progress Bar ...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 > -- 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.