Dlookup function

[Guest]

Hello!

In my Computer an Access application works very good, but in my parnter's
computer doesn't; It show a message "Function is not found". It's about
"Dlookup function" in a calculated field into a Query.

I uninstalled and installed Office 2003 and the Service Pack, but it doesn't
work.

Any help will be appreciated!
Excuse me for my english.

 

[David Pawloski]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

David Pawloski
Microsoft MVP

 

[fredg]

Hello!

In my Computer an Access application works very good, but in my parnter's
computer doesn't; It show a message "Function is not found". It's about
"Dlookup function" in a calculated field into a Query.

I uninstalled and installed Office 2003 and the Service Pack, but it doesn't
work.

Any help will be appreciated!
Excuse me for my english.

That PC has a missing reference.
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with
Microsoft Access'
Or for Access 97:
175484 'References to Set When Working With Microsoft Access' for
the correct ones needed,
and
160870 'VBA Functions Break in Database with Missing References' for
how to reset a missing one.

For even more information, see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html