Results 1 to 13 of 13
  1. #1
    Sheba is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    239

    Exclamation Switchboard items


    Hi, I have 14 items to be placed on my switchboard, each of them will open a form but the switchboard manager is telling me that only eight items can go on the switchboard?!

    Could someone please advise on how to fix this? Thanks much

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You will have to create sub pages.

    I don't use the Access switchboard. I find it too limiting - it is clunky, limiting, hard to modify and ugly. I think the Navigational form is also limiting.

    If you used a standard form, you can build you own "switchboard" with as many options as you want. You can set the colors to whatever you want.



    For instance, in the header of my startup form I have a button to exit Access. There is a text box that lists the name of the currently linked BE. If I double click on the text box I can relink to another BE. If I link to the BE on the server, the bg of the text box is red (live data) otherwise the bg of the text box is green (indicating test data).

    The details section displays the names of out clients (which are company names). When I select a company name list boxes in the footer become enabled.

    In the footer of the startup form are list boxes one of which is for divisions (companies have divisions, divisions have employees). When I select (click on) a division, another list box fills with employees names that are assigned to that division. If I double click on an employee's name, a form opens displaying details about the employee. On that form are several list boxes - one of which displays a few fields about work hours. Double clicking on the list box opens another (editable) form with full details about work hours.

    There are labels along the left side of the startup form footer that I configured to look like buttons. I used labels because I can control the font, font size and FG/BG colors (this was developed using A2000 before there was the ability change button BG colors). I use the mouse down and mouse up events to make the bg change color and to make the special properties change from raised to sunken to raised again. It appears to be a button, but is a label.
    Clicking the labels (buttons) opens other forms.

    I never have a form displayed that does not have data on it, unlike the Access switchboard.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Be aware that this thread is double-posted here:

    http://www.utteraccess.com/forum/Swi...l#entry2489001

    Linq ;0)>

  4. #4
    Sheba is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    239
    Hi Steve. Wow sounds like a lot of real estate work. However, the obvious trade off is that I can get my switchboard to be flexible. I'll start building... many thanks!!

  5. #5
    tonez90 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2014
    Location
    Australia
    Posts
    18
    The other way is place certain switchboard items in a eperate category and only have a few items in each switchboard page. An example could be
    Data Entry - opens another screen with some forms
    Reporting - Opens the reporting screens
    Edit Existing Data - Opens forms in edit mode
    Administration - Opens some forms.

    Dont forget you can have multiple layers on the swithboard.

    Alternatively I like and use my own from forms to act like switchboard. In this way you can add list boxes combo boxes, labels, text boxes etc to help the user along.
    The choice is yours. I would suggest you do a bit of a search to see what would best suit you application. There are hundreds of examples out there so good luck.
    Tony

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    The switchboard wizard can only create 8 items but the switchboard configuration can be manually modified. Requires becoming familiar with the switchboard table.

    I agree with ssanfu. Never liked and never used switchboard or navigation form.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Wow sounds like a lot of real estate work.
    Once you see how effective it is, you won't ever use a switchboard/navigation form again.

  8. #8
    Sheba is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    239
    Many thanks everyone for your response. I doubt I will go near an Access switchboard wizard again.

  9. #9
    Sheba is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    239
    Sorry quick question:

    how do I clear the "grey" colour from my the unchecked optionGroup boxes (and radio buttons).

    i.e. when no selection has been made, they don't have a white blank look but appear to be grey...

  10. #10
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Did you try setting the default value of the check box control to FALSE?
    I think the gray is the unknown value (NULL).

    See http://www.pcreview.co.uk/forums/gra...-t1131715.html
    Last edited by ssanfu; 09-15-2014 at 12:59 PM. Reason: Added URL

  11. #11
    Sheba is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    239
    hey Steve, thanks. I'd previously set the default value(s) to "False" and couldn't figure out what was making some of them look grey and the others white. Setting default to 0 seems to do the trick for this one. Thanks again

  12. #12
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Why use checkboxes in an option group? Radio buttons might be more appropriate.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  13. #13
    Sheba is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    239
    The paper based versions have both radio buttons and check boxes, and that was the format for the forms. Too late to turn back now. Already been to Timbuktu and back with this project and at this stage, I'm doing as I'm told...within reason of course.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-27-2013, 03:53 PM
  2. Replies: 0
    Last Post: 08-05-2012, 11:23 PM
  3. Switchboard
    By mkc80 in forum Access
    Replies: 2
    Last Post: 05-17-2012, 06:44 PM
  4. Replies: 7
    Last Post: 09-13-2011, 01:38 PM
  5. Items With Which items Most Commonly
    By vansicklej in forum Access
    Replies: 3
    Last Post: 08-10-2011, 11:05 AM

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