General discussion

  • Creator
    Topic
  • #2125579

    Access97 to 2000

    Locked

    by jim.brown ·

    the following code i use sucesfully in Access97, it basically minimize the database window leaving the form, but when i try and run this in Access2000 it fails

    The Code is:

    Option Compare Database
    Option Explicit

    Private Sub Form_Open(Cancel As Integer)
    ‘ Minimize the database window and initialize the form.

    On Error GoTo Form_Open_Err

    ‘ Minimize the database window.
    DoCmd.SelectObject acForm, “%formname%”, True
    DoCmd.Minimize

    ‘ Move to the switchboard page that is marked as the default.
    Me.Filter = “[ItemNumber] = 0 AND [Argument] = ‘Default’ ”
    Me.FilterOn = False

    Form_Open_Exit:
    Exit Sub

    Form_Open_Err:
    MsgBox Err.Description
    Resume Form_Open_Exit

    End Sub

    I don’t do to much programming and this one has been driving me nuts

All Comments

  • Author
    Replies
    • #3440878

      Access97 to 2000

      by jim.brown ·

      In reply to Access97 to 2000

      The %formname% is there to remind me where to change it for each form

    • #3440833

      Access97 to 2000

      by maxwell edison ·

      In reply to Access97 to 2000

      There are a number of differences in the database created by Access 97 and Access 2000.

      When you select a database created in Access 97 to open in Access 2000, the Convert/Open Database dialog box appears. You can either convert the database to Access 2000 format or open the database without converting it from Access 97.

      If you select the Convert Database option, you can add, delete and edit records. You can also edit objects in the database and modify the design. Any changes to the database’s records are saved automatically. You do not have to use the File – Save command. If you edit the database objects or modify the design, you must save the database.

      If you select the Open Database option, you can add, delete andedit records and view objects in Access 2000. However, you cannot edit objects in the database or modify the design. Any changes to the database’s records are saved automatically. You do not have to use the File – Save command. The database remains in Access 97 format and can be used in Access 97.

      To convert tables, forms, macros and reports created in earlier versions of Access to Access 2000, choose Help – Microsoft Access Help. Open Getting Started with Microsoft Access> Converting Microsoft Access Databases > Convert a database and select the appropriate Help topic.

      There are a number of Web sites that will outline the differences, and what’s required to make them compatible. Cut and paste these links for some of those articles.

      (REMOVE SPACES from the pasted URLs.)

      http://www.ncs.ncsu.edu/ncs/FAQ/Windows2000/Differences_Office2000.htm

      http://www.mvps.org/access/bugs/

      http://msdn.microsoft.com/library/en-us/dnacc2k/html/ac2kkb.asp?frame=true

      http://www.hammerdata.com/Newsgrp/Bugs.htm

      Good luck,

      Maxwell

    • #3440820

      Access97 to 2000

      by dklippert ·

      In reply to Access97 to 2000

      You don’t need “%formname%”, Just leave the second argument blank.
      Where does it fail?
      Of course, you could use Tools>Startup if it was appropriate.

    • #3449574

      Access97 to 2000

      by j. lovett ·

      In reply to Access97 to 2000

      If you omit “%formname%” it will work

    • #3641413

      Access97 to 2000

      by jim.brown ·

      In reply to Access97 to 2000

      This question was closed by the author

Viewing 4 reply threads