Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397

    Unanswered: How To Know Which Reference Need?

    Hi,

    Do anyone of you have idea how to understand what reference file is needed by access when it display msg 'Data member not found' or 'Data memeber not set' while compiling ?

    With kind regards,
    Ashfaque

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    This cycles thru the references collection, finding the ones that don't work or are missing.

    Function ReferenceInfo()

    Dim strMessage As String
    Dim strTitle As String
    Dim refItem As Reference

    On Error Resume Next

    For Each refItem In References
    If refItem.IsBroken Then
    strMessage = "Missing Reference:" & vbCrLf & refItem.FullPath
    Else
    strMessage = "Reference: " & refItem.Name & vbCrLf _
    & "Location: " & refItem.FullPath & vbCrLf
    End If
    Debug.Print strMessage
    Next refItem

    End Function
    Inspiration Through Fermentation

  3. #3
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397
    Thanks RedNeckGeek,

    I will try to call this fuction at my Err Trap procedure.

    Regards,
    Ashfaque

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    that's all very well, but where will you run this code:

    on your master machine:- i guess you will not find missing references!!

    on each client:- fine! you have a broken client AND you know you have a broken client. then what?? presuming you have issued your application as .MDE how will you get the user to fix the references ...and if you have 200 users with broken references ?????

    at the risk of complicating your life, take a look at this

    izy
    currently using SS 2008R2

Posting Permissions

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