macro to run parameterised function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pradeep - 30 Jul 2007 09:13 GMT

I have a functin 'test' which takes a parameter 'a'. I run the
function using a macro (Runncode). The function appears as
test(<<a>>). Now when i run the macro , it gives me an error like
"Microsoft Access can't find the name <<a>> you entered in the
expression.

please tell me what am i doing wrong

Reply to this Message

Steve Schapel - 31 Jul 2007 02:07 GMT

Pradeep,

Where does the 'a' parameter come from? What sort of data type is it
supposed to be? I don't recognise the syntax with the <<>> delimiters
(or whatever they are)... can you explain what they mean please?

Signature

Steve Schapel, Microsoft Access MVP

> I have a functin 'test' which takes a parameter 'a'. I run the
> function using a macro (Runncode). The function appears as
[quoted text clipped - 3 lines]
>
> please tell me what am i doing wrong

Reply to this Message