[AccessD] IronSpeed

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.





More information about the AccessD mailing list