Results 1 to 5 of 5
  1. #1
    Join Date
    May 2009
    Posts
    30

    Unanswered: Switchboard error/glitch

    Hi

    I have an existing switchboard which links between various switchboard pages. On each page I have a "back" button which is just another switchboard button that links back to the default page (labelled 'back'). This all works fine.
    However, the other day I added an extra button to one of the pages...and subsequently the "back" button linked to the default page has began to behave oddly. Its worth noting that everything actually works fine, and every button does what its supposed to. However, when clicking the "back" button the button remains on the switchboard transferring its self to the default page.
    Hard to explain, so I have attached a picture.

    Ive checked over the properties and switchboard tables and everything looks fine...so im out of ideas.

    All help appreciated.
    Attached Thumbnails Attached Thumbnails dberror.JPG  

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Beats me, I never use the switchboard; I make my own interface. I recommend you do the same.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Just get rid of using the switchboard! It's a poor MSAccess "feature".

    For multi-user mdb's, it's just not a good idea to have the Main Menu (what the user will most likely leave open all day when they minimize the app), not bound to an actual table.

    Keep the recordsource for your Main Menu's blank (no recordsource) and design your own buttons to open other forms. It'll make your life much easier.

    As ST stated, I think you'll find most experienced developers avoid the switchboard (like the plague!)

    Regarding your question with the Back button appearing, someone will have to answer it who uses the switchboard regularly. I can only guess that there's something in the switchboard code or tables which is causing it (another reason I avoid it - one less hassle to deal with.)
    Last edited by pkstormy; 09-05-09 at 03:24.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    May 2009
    Posts
    30
    Sorted.

    I deleted the thing and made a better menu.

    Thanks anyway

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Good job! Better for you, better for your users!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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