Results 1 to 8 of 8
  1. #1
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754

    Switchboard Main Menu assistance

    Hi all,
    OK, so i started a switchboard (Attached)


    On open, It goes to Main Menu like it should however, the caption on Main Menu is Companies and Contacts?
    Why on earth is it doing that, it should say Main Menu

    Please let me know...all other buttons are correct in the lable and pages? Makes no sense
    Thanks
    DaveProfileLogIn.zip

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    switchbdID: 1
    ItemNumber: 0
    ItemText : Main Menu
    command: [blank]
    arg: default

  3. #3
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Is this something i did creating it or ? I dont understand why all of the others put the correct lable in header but this one? I dont understand what i did nor how to fix it?

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    I have had this happen to me in the past as well, and never found out why it happens.?
    FWIW I cannot see why it is doing it either.?
    The Dlookup should get the first record with the ID of 1, but it does not.

    I used to keep a backup after each edit and just restore when this happened.

    Change the macro for On Open for both labels to
    Code:
    =DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID") & " AND  ItemNumber = 0")
    HTH

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    However I've noticed now, that when you go to a sub menu and return, it is back to Companies....

    If you also add it to the Option macro code for Command = 1, that appears to cure it.

    Still no idea as to why it is going wrong.

  6. #6
    d9pierce1 is offline Expert
    Windows 10 Access 2016
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    754
    Thank you so much. I thought i was loosing my mind....
    Really, Thank you
    Dave

  7. #7
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I downloaded the attached zipped dB in Post #1.
    I extracted the accdb from the zip.
    I opened the dB.
    I opened the Switchboard form.
    The header shows "Companies and Contacts".
    I clicked on "Accounting", then "Main Menu".
    The header shows "Companies and Contacts".
    I did a "Compact and Repair"(DATABASE TOOLS/Compact and Repair).
    I opened the form "Switchboard".
    I clicked on "Accounting", then "Main Menu".
    The header now shows "Main Menu".
    I cycled through the rest of the options under Main Menu.
    Now, when at the "Main Menu", the header always shows "Main Menu".


    There are times when Access gets stuck/confused and you need to do a garbage collection ("Compact and Repair"). Or, worst case, you would need to do a decompile/compile.
    I will do a C&R many times during a session of making changes or editing code.

  8. #8
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    @ssanfu
    Thank you for at least getting to the bottom of the problem. I was still trying to understand what was causing it even though it was not my problem.
    However as I mentioned I have had that happen several times to me when I was using Access in my last place of work.
    Having found a workaround yesterday, I would use that from now on, apply once, use always, if I was still in a working environment.
    C&R would then be my second choice.

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

Similar Threads

  1. Replies: 1
    Last Post: 06-29-2016, 02:47 PM
  2. Replies: 2
    Last Post: 04-11-2014, 02:27 PM
  3. Switchboard not showing all menu options
    By mandykoonts in forum Forms
    Replies: 1
    Last Post: 01-28-2014, 05:51 PM
  4. Main Switchboard
    By mamig in forum Access
    Replies: 3
    Last Post: 01-27-2010, 09:07 AM
  5. SWITCHBOARD MANAGER DISABLED ALL THE MENU AND EDIT OPTION
    By ranjit_dutt in forum Programming
    Replies: 0
    Last Post: 04-13-2007, 08:39 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