Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is there a compare utility? (Access 2000)

    Is there a utility that you can use to compare two different Access databases (including the VB code)? I have a form that was working before, now it's not. I have a copy of the database from a few days ago when my form was working. I don't remember changing anything on that form. It is now highlighting in yellow the "Sub Form_Current(). And the word Error$ is highlighted in blue saying that it can't find the project or library.

    Sub Form_Current()
    On Error GoTo Form_Current_Err

    If ChildFormIsOpen() Then FilterChildForm

    Form_Current_Exit:
    Exit Sub

    Form_Current_Err:
    MsgBox Error$
    Resume Form_Current_Exit

    End Sub

    I don't know what's going on.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Is there a compare utility? (Access 2000)

    In the Visual Basic Editor, select Tools | References...
    Do you see any reference starting with MISSING? If so, clear its check box.
    Then click OK, and select Debug | compile <project> to see if the code is recognized now.

    About comparing databases, see the thread starting at <post#=351524>post 351524</post#>.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is there a compare utility? (Access 2000)

    Thanks, as usual, Hans! Boy, learning Access/VBA is becoming a life-long process. I learn a little bit each day.

Posting Permissions

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