On Thu, 14 Jun 2007 21:38:19 -0000, k-man <kmccrack@gmail.comwrote:
Sorry, no can do. From ASP you don't have access to the Access VBA
interpreter.
-Tom.
Quote:
>Hi:
>
>I have an MS Access query for a table called MyTable. One of my
>fields in the query is a custom field that looks like "MyField: =
>MyFunction(ID)" where ID is a field in MyTable.
>
>I have ASP code and I can use it to read the query OK when "MyField"
>is not part of the query. If I add in MyField and then run my ASP
>code to try to read all the query fields, I get an error message on my
>web browser which says something to the effect of "cannot find
>MyFunction." On the Access side, I have MyFunction set up in a module
>and use the keyword "Public" in front of the function name. What else
>do I need to do to get my ASP code to run this query. I'm trying to
>avoid reproducing MyFunction within the ASP code if possible.
>
>Thanks.
>Kevin