Elookup Error 3131

[iccsi]

I tried to use ELookup from Allen and got Error 3131 message when I
run it.
I just changed my DLookup to ELookup.

Does ELookup support Access 2003?
Do I need change any code from DLookup?
Are there any limitations for ELookup?


Your information is great appreciated,

 

[inungh]

I tried to use ELookup from Allen and got Error 3131 message when I
run it.
I just changed my DLookup to ELookup.

Does ELookup support Access 2003?
Do I need change any code from DLookup?
Are there any limitations for ELookup?

Your information is great appreciated,

it seems that it does not support table name has space like

MY TABLE NAME

Are there any work around for this?
Thanks again,

 

[inungh]

it seems that it does not support table name has space like

MY TABLE NAME

Are there any work around for this?
Thanks again,

I tried to modified like following

strSql = "SELECT TOP 1 " & Expr & " FROM " & "[" & Domain & "]"

it runs in the query design, but I got 3061 3 parameters expected when
runing in ELookup.

Any idea or suggestions?

Thanks millions,

 

[inungh]

it seems that it does not support table name has space like

MY TABLE NAME

Are there any work around for this?
Thanks again,

I tried to modified like following

 strSql = "SELECT TOP 1 " & Expr & " FROM " & "[" & Domain & "]"

it runs in the query design, but I got 3061 3 parameters expected when
runing in ELookup.

Any idea or suggestions?

Thanks millions,- Hide quoted text -

- Show quoted text -

I am thinking that I use MY QUERY as Domain and the query does not
need parameter, but the stack query uses a query which has 3
parameters.

It seems the problem.
The query works fine with DLookup, but It gets 3131 error SQL
statement error, it gets 3160 error if I change the Domain as [My
QUERY].

any sugeestions for workaround for this?


Your help and information are great appreciated,

 

[inungh]

I tried to modified like following

 strSql = "SELECT TOP 1 " & Expr & " FROM " & "[" & Domain & "]"

it runs in the query design, but I got 3061 3 parameters expected when
runing in ELookup.

Any idea or suggestions?

Thanks millions,- Hide quoted text -

- Show quoted text -

I am thinking that I use MY QUERY as Domain and the query does not
need parameter, but the stack query uses a query which has 3
parameters.

It seems the problem.
The query works fine with DLookup, but It gets 3131 error SQL
statement error, it gets 3160 error if I change the Domain as [My
QUERY].

any sugeestions for workaround for this?

Your help and information are great appreciated,- Hide quoted text -

- Show quoted text -

I beleive the issue us OpenRecordset does not recognize the query
which call a query with parameter in the module.

I did a test to pass a SQL string to my function using a query which
calls a query with parameter in a module then I got same error
message.

I think the workaround is to put the ELookup on the form as a private
function or to pass full parameters using criteria paramter to use
ELookup.

Thanks all for helping,


OpenRecordset