Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Sydney, Australia, New South Wales, Australia
    Thanked 4 Times in 4 Posts

    List of available references (Access 2000)

    I want to programatically determine is a particlar reference is available.
    That is, when you go into the VBA editor, Tools, References all references available are listed.
    It's easy to find out the ones that are active (ticked) using the Application.References collection.
    As I am using late binding (CreateObject rather than New), that object is not ticked. Some machines have the control I'm interested in installed; others don't.
    I want to determine that via code.

    Yes, I could look for the DLL's existence, but it may not be installed in the same directory, or it might exist but not have been registered.

    In <post#=627923>post 627923</post#>, the idea is to use On Error. But this causes all sorts of drama if the user has Error Trapping - Break on all errors set.

    Thanks for any ideas.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: List of available references (Access 2000)

    From a newsgroup search, I get the impression that there is no practical way to retrieve the list of all available references. The info is stored in the registry, but you'd have to trawl through various parts of HKEY_LOCAL_MACHINE.

    You should instruct your users to turn off "Break on all errors" anyway - it wreaks havoc with all error handling in your code.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts