[AccessD] Access Check References

Max Wanadoo max.wanadoo at gmail.com
Wed May 27 01:41:58 CDT 2009


Hello my friend, William.

I would put a break point in.  Goto Immediate Window and type in each part
of the properties you reference to see which property returns which value.

? Chkref.name
? Chkref.major
? Chkref.minor
? Chkref.fullpath


Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: 27 May 2009 06:59
To: Access Developers discussion and problem solving
Subject: [AccessD] Access Check References

Group

...I'm running the following code within a private sub in my startup form:

    Dim chkref As Reference

    For Each chkref In Application.References
        strLog = strLog & IIf(chkref.IsBroken, "## Broken Reference", "OK") 
& " ref: " & chkref.Name _
               & " " & chkref.Major & "." & chkref.Minor & " " & 
chkref.FullPath & vbNewLine
    Next

...works like a charm ...except that the log reads as follows:

OK ref: VBA 4.0 C:\Program Files\Common Files\Microsoft 
Shared\VBA\VBA6\VBE6.DLL
OK ref: Access 9.0 C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB
OK ref: DAO 5.0 C:\Progra~1\Common~1\Micros~1\dao\dao360.dll
OK ref: stdole 2.0 C:\WINDOWS\system32\stdole2.tlb
OK ref: ADODB 2.8 C:\Program Files\Common Files\System\ado\msado15.dll

...where the heck did the VBA 4.0/Access 9.0/DAO 5.0 come from?

 William
 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list