By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,949 Members | 1,554 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,949 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Jun 14 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Thu, 14 Jun 2007 21:38:19 -0000, k-man <km******@gmail.comwrote:

Sorry, no can do. From ASP you don't have access to the Access VBA
interpreter.

-Tom.
>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
Jun 15 '07 #2

P: n/a
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:
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.
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- Hide quoted text -

- Show quoted text -

Jun 15 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.