elookup or extended dlookup

[Guest]

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.

 

[Douglas J. Steele]

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.

 

[Allen Browne]

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.

 

[Guest]

Thank you Allen and Douglas.

This makes complete sense now.

I appreciate your quick response.