Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2004
    Posts
    5

    Unanswered: How do i prevent a user closing the switchboard?

    Hi

    is there a way of either

    1. stoping the switchboard from closing when a user clicks the x or does a file close

    or

    2 getting the switchboard to open again once it has closed

    or

    3 canceling the close command in some way.

    i have tryed to create a macro running from the "on close" event that says open form switchboard but it wont open it.

    any ideas?

    thanks

    stephen

  2. #2
    Join Date
    Apr 2002
    Location
    Illinois
    Posts
    133
    Open the form in design view. Open the Properties window for the form and select "No" for CloseButton property.
    SteveH

  3. #3
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Hi

    stopping the close form in the file option in certain situations can be a dangerous thing. Corruptions etc BUT the X control is found in the forms PROPERTIES section. To get to the main form properties click on the small square, top left side of the form adjacent to the rule. change close button from yes to no

    hope this helps you

    regards

    Gareth

  4. #4
    Join Date
    Mar 2004
    Posts
    6
    Open the form in design view, open the form properties and change the Navigation button to No.

    Hope this helps.

  5. #5
    Join Date
    Nov 2003
    Posts
    104
    Quote Originally Posted by SteveH
    Open the form in design view. Open the Properties window for the form and select "No" for CloseButton property.
    That's the ticket

  6. #6
    Join Date
    Feb 2004
    Posts
    126
    I avoid that problem all together by not using a switchboard, instead I just use a toolbar, it's always there, and the user has to go through a lot more effort to get rid of it.

    SelectTools>Customize and go to the Commands tab, if you scroll down the categories list you will see "All Forms", "All Reports", etc. Just drag it to a toolbar and you're good to go. Umm...actually I guess I created a new toolbar, but I don't remember how I did that. But anyway, you get the idea.

    The application is constantly evolving as new reports and functionality is added to it. And this way, the users get used to using a common interface, and as a new report is added, I just add a new button to the toolbar, and if they are related, I just add a new menu to it which allows a consistent, simple interface to everything they need.

    I think it's best asset is that it is unobtrusive. There is no need to force a switchboard to pop-up everytime all the windows are closed.

    Just and idea, good luck!

  7. #7
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    One more Tick I use

    in the form Properties
    menu bar put =1

    it hides the File edit .... menu across the top
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  8. #8
    Join Date
    Apr 2004
    Posts
    5
    Thanks for the help,

    the reason i ask is that i have created a tool bar with a close form button on it that runs a macro. the macro says:

    runcommand: close

    it works perfectly (maybe to perfectly) because even though i have already done as you all sugjested and disabled the x close button in the form properties my switchboard still closes when i use this button

    anyhow thanks again.

  9. #9
    Join Date
    Feb 2004
    Posts
    126
    I haven't done this before, but can you try something like this,

    If NOT Screen.Activeform.name = "Switchboard" then
    runcommand: close
    End If

    Check Microsoft Help for more on the .ActiveForm property.

Posting Permissions

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