Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Exit Switchboard to Database Window

Discussion in 'Information Technology' started by J, Jul 28, 2006.

  1. J

    J
    Expand Collapse
    Guest

    Currently the switchboard opens upon opening the database, which I want to
    keep, but I want to add a button to Exit Switchboard to Database Window to
    allow access to the Tables, Queries, Reports, etc.

    What is the correct code for the macro command? The macro needs to close
    the switchboard or put it to the back and open up the Database Window.

    Please help!
     
  2. Loading...

    Similar Threads Forum Date
    World An Exit Plan for Mubarak Breaking News Feb 4, 2011
    SciTech Tools Suggest Earlier Human Exit From Africa Breaking News Jan 30, 2011
    Two opposite news: One depressing & another exiting Community Out-Reach Oct 26, 2009
    Sikh News President be made accountable instead giving safe exit: Punjab CM (The Pakistan Link) Breaking News Aug 17, 2008
    Sikh News Capt's shrine visit raises storm, BJP-Akalis demand his exit (Outlook India) Breaking News Jun 22, 2005

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Use the Close action to close the form

    Use SelectObject to choose the database window.
    Choose whatever tab you like.
    Leave the object name out if you wish, but you must set the last argument of
    SelectObject to Yes so that it selects the database window.

    If you are closing a bound form, make sure you save any edits that are in
    progress, or Access will silently discard them. More info in this bug:
    Losing data when you close a form
    at:
    http://allenbrowne.com/bug-01.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "J" <J@discussions.microsoft.com> wrote in message
    news:29B76AA6-E7E4-4D7B-ACB9-21248476C1E0@microsoft.com...
    > Currently the switchboard opens upon opening the database, which I want to
    > keep, but I want to add a button to Exit Switchboard to Database Window to
    > allow access to the Tables, Queries, Reports, etc.
    >
    > What is the correct code for the macro command? The macro needs to close
    > the switchboard or put it to the back and open up the Database Window.
    >
    > Please help!
     
  4. J

    J
    Expand Collapse
    Guest

    That worked Great!! Thank you for your help.

    "Allen Browne" wrote:

    > Use the Close action to close the form
    >
    > Use SelectObject to choose the database window.
    > Choose whatever tab you like.
    > Leave the object name out if you wish, but you must set the last argument of
    > SelectObject to Yes so that it selects the database window.
    >
    > If you are closing a bound form, make sure you save any edits that are in
    > progress, or Access will silently discard them. More info in this bug:
    > Losing data when you close a form
    > at:
    > http://allenbrowne.com/bug-01.html
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "J" <J@discussions.microsoft.com> wrote in message
    > news:29B76AA6-E7E4-4D7B-ACB9-21248476C1E0@microsoft.com...
    > > Currently the switchboard opens upon opening the database, which I want to
    > > keep, but I want to add a button to Exit Switchboard to Database Window to
    > > allow access to the Tables, Queries, Reports, etc.
    > >
    > > What is the correct code for the macro command? The macro needs to close
    > > the switchboard or put it to the back and open up the Database Window.
    > >
    > > Please help!

    >
    >
    >
     

Share This Page