Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exit to Access (2K)

    Am I going crazy? I'm sure there used to be a command used in macros to close the current database leaving Access open. The textbook supplied by the Institute where I teach asks the student to create a command button on both a menu form and switchboard to Exit to Access...I can only manage Exit to Current Database window or Exit Access. I would assume an error in the text but can't quite convince myself that Exit to Access is not possible! <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Cheryl =^..^=

    IS Support, Adelaide <img src=/S/granny.gif border=0 alt=granny width=20 height=20>

    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Exit to Access (2K)

    Try Application.CloseCurrentDatabase in code. In a macro, use a SelectObject action, specify and object but not a name (i.e., Table, but leave the object name blank) and set the In Database Window to yes. The next action should be RunCommand with a Command of Close.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exit to Access (2K)

    Thanks for that...you've saved my sanity <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Cheryl =^..^=

    IS Support, Adelaide <img src=/S/granny.gif border=0 alt=granny width=20 height=20>

    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •