• Is there a compare utility? (Access 2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Is there a compare utility? (Access 2000)

    • This topic has 4 replies, 2 voices, and was last updated 21 years ago.
    Author
    Topic
    #405663

    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.

    Viewing 1 reply thread
    Author
    Replies
    • #835377

      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 to see if the code is recognized now.

      About comparing databases, see the thread starting at post 351524.

      • #835399

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

      • #835400

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

    • #835378

      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 to see if the code is recognized now.

      About comparing databases, see the thread starting at post 351524.

    Viewing 1 reply thread
    Reply To: Is there a compare utility? (Access 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: