1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access Database - References

Discussion in 'Business Applications' started by computerman29642, Feb 18, 2009.

Thread Status:
Not open for further replies.
Advertisement
  1. computerman29642

    computerman29642 Thread Starter

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Is there a way to check or uncheck references using code in Access?

    I have a database that will be opened by Access 2003 or 2007. Both versions will need to be able to use the Access Reference "Microsoft Outlook 11.0 Object Library" or "Microsoft Outlook 12.0 Object Library".
     
  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,694
  3. computerman29642

    computerman29642 Thread Starter

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    What do you know about "Late Binding"? I have read that if late binding is done, I would not need to check the reference.
     
  4. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,694
    It is in my Access 2000 book, but I haven't taken much notice of it.
     
  5. computerman29642

    computerman29642 Thread Starter

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    I have a Function that checks the version of Access being used. I have code that will add the Reference needed. The code I am trying to get to work now is the one that will remove the "Missing" reference.

    Here is some code that I found, but have unsuccessful in getting it to work.

    Code:
    Dim refCurr As Access.Reference
    Dim intCount As Integer
    
    For intCount = Access.References.Count To 1 Step -1
    Set refCurr = Access.References(intCount)
    If Not refCurr.BuiltIn Then
    If refCurr.IsBroken Then
    Access.References.Remove refCurr
    End If
    End If
    Next
    
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/802104

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice