dlookup vs. elookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tgl - 13 Nov 2006 18:07 GMT

we use reports in Access 2003 that use DLOOKUP in text box/control source.
ELOOKUP does not appear to work in this situation, is that correct???

thanks in advance!

Signature

tgl

Reply to this Message

Douglas J. Steele - 13 Nov 2006 18:23 GMT

You talking the function Allen Browne has at
http://www.allenbrowne.com/ser-42.html?

I don't see any reason why it shouldn't work. What happens when you try to
use it?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> we use reports in Access 2003 that use DLOOKUP in text box/control source.
> ELOOKUP does not appear to work in this situation, is that correct???
>
> thanks in advance!

Reply to this Message

tgl - 15 Nov 2006 17:34 GMT

I am using same language as DLookUp but in a control source of a text field
(not VBA as in Allen Browne’s example): Report opens with “ENTER PARAMETER
VALUE: ELookUp”

Control source in TEXT field in report reads:

=ELookUp("[TABLE NAME]","AAADIAGRAM","[TABLE NUMBER]=TABLE1")

another TEXT field/control source identifies TABLE1

I should explain why I’m using ElookUp:
We successfully have used DLookUp for years in reports using above
programming/syntax (in both access 2002 & 2003).
Have recently had trouble with "The Search key was not found in any record".
In these reports, not accepting changes, deletions, name changes etc…

First suggestion was checking reference but we had already checked off:
ActiveX Data Lookup & DAO 3.6. Sometimes just opening references and
clicking OK and saving does help problem, but we can’t rely on that.

So…Second suggestion: DLookUp was causing issues should use ELookUp instead?

Would appreciate any thoughts you have!!! Thanks in advance!

Signature

tgl

> You talking the function Allen Browne has at
> http://www.allenbrowne.com/ser-42.html?
[quoted text clipped - 6 lines]
> >
> > thanks in advance!

Reply to this Message

tgl - 20 Nov 2006 21:14 GMT

did you have any ideas why elookup doesn't appear to work in a text field of
a report??
i really appreciate your help on this!!

Signature

tgl

> I am using same language as DLookUp but in a control source of a text field
> (not VBA as in Allen Browne’s example): Report opens with “ENTER PARAMETER
[quoted text clipped - 30 lines]
> > >
> > > thanks in advance!

Reply to this Message

Douglas J. Steele - 20 Nov 2006 22:53 GMT

What do you mean by "using same language as DLookup ... (not VBA...)"?

What is ELookup if not a VBA function?

Also, what do you mean by "doesn't appear to work in a text field of a
report"? What happens when you use it? Do you get an error? If so, what's
the error message?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> did you have any ideas why elookup doesn't appear to work in a text field
> of
[quoted text clipped - 41 lines]
>> > >
>> > > thanks in advance!

Reply to this Message