Something like this, let me know how you make out.
--Richie
Dim appAccess
Dim db
Dim qd
Dim rs
Dim c
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase "base.mdb", False
Set db = appAccess.DBEngine.Workspaces(0).Databases(0)...
Why export to HTML? Another approach may be to use your openquery, like you have, but change that query to a "make table query" and then use ADO on the result set?
I do not believe there is a way to use ADO on a recordset who uses a custom function.
Workarounds...
(1) Re-write the function in VBScript and process your SQL server side in your ASP page.
(2) Create an Access.Application on the server, open the database with that object, then call a macro...
Thanks for your post, but that was not my question.
I am seeking a more advanced rules viewer/tool. One that would let me seach the ones I have already setup, and perhaps give me a detail view where I can see more information at a glance, at many of them, not just the name.
Scenario: Have...
I am looking for an "Outlook Rules Viewer", or a way to search through the text of the rules I have set up. Does anyone know of a way within Outlook (2002), or any other program, to do this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.