Drew Wutka
DWUTKA at Marlow.com
Fri Jan 30 18:39:01 CST 2009
Actually, I built something that was going to lead to that. Started as a web report runner. It would give you a list of reports in a database (did this back in the 97 days), when you selected a report, it would display any prompts that Access sees (logon prompts, query expression prompts, etc) to the user in their browser, and then when the report ran, it would let the user open it as HTML or download it in any of the formats Access allowed. Worked great. Tried to do the same with forms, and ran into the issue that Access forms are not 'normal' windows. There is only one active control, none of the inactive controls are actual windows (like most controls on normal windows are). Had other projects come up, so I never dug back into it. For S & G's , I put two exe's in http://www.marlow.com/CriteriaGrabber.zip (That link may only be active for a while, we're moving our website soon). One is CriteriaGrabber.exe. Run that program. Open an Access 97 database. Run WindowsInfo.exe, move the mouse over the title bar of the Access Window (the Class should show OMain). Take the hWnd of the Access Window and replace Text1 (in the CriteriaGrabber), then click start timer. Now, whenever a 'popup' window (not a form) is displayed in access, the Criteria Grabber will display it's own 'mimicked' version of that dialogue window, and even 'remotes' it. (ie, if it's a prompt for criteria, you can put the criteria into the 'copy' and click the appropriate button, and it will push that data (and whatever button you pushed) to the actual dialog window. That .exe is just a test I was running, the actual system does something very similar, but sends an HTML version of the dialog windows through to the users. Access 2003 has changed the class names of the dialog windows, so my .exe won't mimic labels or text boxes..... go figure.... Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Thursday, January 29, 2009 3:39 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] IronSpeed Thanks John - agreed. It would have been nice to "pop in" an MDB at one end and get "pop out" a Web enabled version at the other. A la PDF-Word converters. Sort of "shell" that the mdb runs in within the browser. Pipe dreams I suppose. Thanks Max On Thu, Jan 29, 2009 at 9:09 AM, <johncliviger at aol.com> wrote: > Hi Max > > No never used IronSpeed. It looked like hard work. And judging by what > others are saying on this board I took the right decision. > > john c > > > -----Original Message----- > From: Max Wanadoo <max.wanadoo at gmail.com> > To: 'Access Developers discussion and problem solving' < > accessd at databaseadvisors.com> > Sent: Wed, 28 Jan 2009 20:38 > Subject: [AccessD] IronSpeed > > > > John Cliviger: > > John, do you (or anybody) have any experience of deploying MS Access DBs to > IronSpeed? > > http://www.ironspeed.com/products/DownloadNow.aspx?c=CP02 > > Thanks > Max > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > ________________________________________________________________________ > AOL Email goes Mobile! You can now read your AOL Emails whilst on the move. > Sign up for a free AOL Email account with unlimited storage today. > -- > 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.