Need to find unresolved references

[Gary Roach]

I want to get a list of all unresolved references in the code in all modules
of an access database (without having to find a way to execute all code
paths). How do I do this? Thanks.

 

[James A. Fortune]

I want to get a list of all unresolved references in the code in all modules
of an access database (without having to find a way to execute all code
paths). How do I do this? Thanks.

Use Option Explicit in each module, then Compile All Modules?

James A. Fortune
(e-mail address removed)

 

[Gary Roach]

I tried that (using Access from Office 2007) but it failed to recognize that
the access application's object's Filesearch method no longer exists.

 

[Paul Shapiro]

Open the VBA editor. On the Tools menu click the References item. The
References that have been specified for the db will be at the top of the
list with the checkbox checked. See if any of the reference names are
prefixed with the word 'MISSING: '. If the db was developed on a different
machine, or with different software versions, those references are needed
but not found on the current machine.
Paul Shapiro

 

[Gary Roach]

Thanks for the reply. Unfortunately that technique doesn't work because the
application object is part of the access object library. The library that
the program was written for was version 10 (Office XP) and the new version
is version 12 (2007). This reference gets automatically updated to point to
the new version. The new version still has an application object, but it
doesn't have a "Filesearch" method.

 

[John W. Vinson]

Thanks for the reply. Unfortunately that technique doesn't work because the
application object is part of the access object library. The library that
the program was written for was version 10 (Office XP) and the new version
is version 12 (2007). This reference gets automatically updated to point to
the new version. The new version still has an application object, but it
doesn't have a "Filesearch" method.

Well... don't know if there's any way to find *all* invalid references, but
you can surely use the "binoculars" search tool to search the entire project
for the word "Filesearch".

 

[Gary Roach]

True enough. So long as Microsoft hasn't deprecated anything else!