elookup or extended dlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

backToAccess - 17 Dec 2006 13:51 GMT

I have seen a couple of postings regarding elookup and went to Allen Browne's
site to learn more about it. However, my vba does not recognize the elookup
at all. It also does not appear in my expression builder as a built in
function. I searched the Microsoft website and they do not seem to have
anything about it in their knowledge base.

I am running Access 2002. I would appreciate any suggestions? Is there a
reference that I am suppose to have selected?

Thank you for your time.

Reply to this Message

Douglas J. Steele - 17 Dec 2006 14:11 GMT

You're supposed to copy the function from the bottom of that page (between
the 2nd and 3rd hortizontal lines) into a new module. Make sure you don't
name the module ELookup: Modules cannot be named the same as functions or
subs contained within them.

Signature

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

>I have seen a couple of postings regarding elookup and went to Allen
>Browne's
[quoted text clipped - 9 lines]
>
> Thank you for your time.

Reply to this Message

Allen Browne - 17 Dec 2006 14:18 GMT

ELookup() is not a built-in function.
You need to copy the code from:
http://allenbrowne.com/ser-42.html
and paste it into a module in your database (i.e. click the Modules tab of
the Database window, click New, paste the code, and save the module with a
name such as "Module1".)

ELookup() has just been updated to handle multi-valued fields in Access
2007. It returns a concatenated list of the key values (as DLookup() does.)
It still works with earlier versions, of course.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have seen a couple of postings regarding elookup and went to Allen
>Browne's
[quoted text clipped - 9 lines]
>
> Thank you for your time.

Reply to this Message

backToAccess - 17 Dec 2006 14:44 GMT

Thank you Allen and Douglas.

This makes complete sense now.

I appreciate your quick response.

> ELookup() is not a built-in function.
> You need to copy the code from:
[quoted text clipped - 20 lines]
> >
> > Thank you for your time.

Reply to this Message