Connecting Tech Pros Worldwide Help | Site Map

Use ASP to read MS Access query that calls MS Access function

k-man
Guest
 
Posts: n/a
#1: Jun 14 '07
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

Tom van Stiphout
Guest
 
Posts: n/a
#2: Jun 15 '07

re: Use ASP to read MS Access query that calls MS Access function


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
k-man
Guest
 
Posts: n/a
#3: Jun 15 '07

re: Use ASP to read MS Access query that calls MS Access function


Yeah, I guess that's true. I'm not really running MS Access itself am
I. Guess I'll have to reproduce the code into ASP.

Thank you for the insight.

Kevin


On Jun 14, 9:52 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
Quote:
On Thu, 14 Jun 2007 21:38:19 -0000, k-man <kmccr...@gmail.comwrote:
>
Sorry, no can do. From ASP you don't have access to the Access VBA
interpreter.
>
-Tom.
>
>
>
Quote:
Hi:
>
Quote:
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.
>
Quote:
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.
>
Quote:
Thanks.
Kevin- Hide quoted text -
>
- Show quoted text -

Closed Thread


Similar Microsoft Access / VBA bytes