Web Development

Ask something
Discussion Locked

Access97 to 2000

0 helpful
9 replies

by jim.brown

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

9 replies

by maxwell edison

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

by dklippert

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.

This discussion is closed to new replies.