Need to find unresolved references

  • Thread starter Thread starter Gary Roach
  • Start date Start date
G

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.
 
Gary said:
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.
Click to expand...

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

James A. Fortune
(e-mail address removed)
 
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.
 
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
 
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.
 
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.
Click to expand...

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".
 
Back
Top