Results 1 to 5 of 5
  1. #1
    rickford66 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2015
    Posts
    3

    Two databases, one closes, one doesn't. What's the difference?

    I have two databases programmed long ago in Access. I believe they are up to Access 2007. Both have a switchboard with an exit button. Both exit when the button is presses, but one closes completely and the other closes to a page that allows the user to select from a bunch of optons. The display shows Access in the upper left corner, under that Recent and under that the databases that I've been using. To the right of that is a whole bunch of selections, such as custom web app, blank desktop database, etc.


    The code for the exit buttons are the same for both databases...
    Code:
           ' Exit the application.
            Case conCmdExitApplication
                CloseCurrentDatabase
    Is there a setting somewhere that I can change to make the database that doesn't completely close do so? I'm not a database programmer, and have very little experience with VBA.
    Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    CloseCurrentDatabase must be a custom function? That's where the code actually is I suspect. Try

    Application.Quit
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    rickford66 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2015
    Posts
    3
    That did it. Thanks.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help, and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    rickford66 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2015
    Posts
    3
    Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Set focus when pop up form closes
    By projectpupil7 in forum Access
    Replies: 4
    Last Post: 11-15-2014, 02:02 PM
  2. Macro that runs when access closes
    By kdbailey in forum Macros
    Replies: 10
    Last Post: 02-01-2014, 12:20 PM
  3. Replies: 2
    Last Post: 08-29-2013, 01:19 PM
  4. Form closes after mssage box
    By liam01752 in forum Programming
    Replies: 1
    Last Post: 12-06-2010, 03:30 PM
  5. Change to Form Closes Access
    By jbhjm in forum Forms
    Replies: 5
    Last Post: 04-22-2009, 01:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums