Requirement to Save As When Opening a Database

  • Thread starter Thread starter lu
  • Start date Start date
L

lu

I teach an introductory MSAccess 2007 class. We have found that many times
when we open a saved database, it requires us to Save As with a number
automatically added to the end of the name. Any ideas on why and how to avoid
this?
 
Lu

In the OnOpen() Event of the MainMenu see if there is a Save command
inserted

Either delete the command line or REM it so it is skipped when the OnOpen()
Event is triggered.

HTH
Mark.
 
Lu

Do you have access rights to edit the MainMenu of the DB, or for that
matter, any of the forms in it.

If you don't, then you need to find out from your IT department if they will
do it for you.

If you do, then open the MainMenu in DesignMode and go to the forms
properties, then click on the EventsTab, then look for the OnOpen line, it
will have [Event Procedure] beside it, click on the CmdBtn [...] to open it
in VB editor.

Once you done this you check if there is a save Cmd line.

(note), also check, OnLoad(), OnActivate() too.

If you find a Save Cmd Line, you can either delete the line or put (Rem) in
front of the line so it will be skipped when the event is triggered.

HTH
Mark.
 
Back
Top