General discussion

Locked

Access97 to 2000

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

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

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

Collapse -

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

Collapse -

Access97 to 2000

by jim.brown In reply to Access97 to 2000

Poster rated this answer

Collapse -

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.

Collapse -

Access97 to 2000

by DKlippert In reply to Access97 to 2000

Have you found a solution to your problem yet?

Collapse -

Access97 to 2000

by jim.brown In reply to Access97 to 2000

Poster rated this answer

Collapse -

Access97 to 2000

by J. lovett In reply to Access97 to 2000

If you omit "%formname%" it will work

Collapse -

Access97 to 2000

by jim.brown In reply to Access97 to 2000

Poster rated this answer

Collapse -

Access97 to 2000

by jim.brown In reply to Access97 to 2000

This question was closed by the author

Back to Web Development Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums