[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

Access Switchboard fails to return to previous menu, but only if options were run in THAT menu?

I have a complex, "deep" switchboard (built-in that comes with Access) and on three of the submenus, the 'return to Previous menu" options work fine, as long as neither o the two report options on them are actually clicked on.  They all three return to the calling menu, as they should.

However, if either of the two actual options are executed (macros which build and display a table plus build a spreadsheet from that table), THEN clicking the 'return to previous menu'  no longer returns to the previous menu -- it doesn't "do" anything that is apparent.

The entire switchboard must be closed and reopened, in order to continue with the program.

Any ideas?  Logically, it's something that goes on in the programs being executed . . . do you need more details of what they do?

Thanks,
Bill C
0
bcreen
Asked:
bcreen
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
The only thing I can think of is ... some sort of error is occurring and not being seen, or masked in some way.  This is way I don't use the switchboard, as it's generally hard to troubleshoot issues of this nature.

mx
0
 
bcreenAuthor Commented:
Are there any superior 3rd party REPLACEMENTS for the ole Switchboard in Access?  Maybe something that can optionally import a current switchboards properties and entries, etc.?

What do YOU use in it's place?  just manually-coded forms?

Thanks for your response!
Bill C
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"What do YOU use in it's place? "
I've (easily) been creating my own custom menu, toolbars and popups for years.  


Everything you need is here - no code ... see this link:

http://www.jamiessoftware.tk/articles/menubars.html
       
Not sure it that article mentions it, but ... when you are in the Customize mode (dialog) ... if you hold down the Control key, you can drop and drag (ie, copy) menu items from one place to another ... handy for making a new menu that is similar another one.


mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Switchboard Alternatives:

http://www.peterssoftware.com/abs.htm

Several here:

http://www.aadconsulting.com/swbds.html

btw ... I've have checked out all of the above swb's ... and they are all pretty cool in one way or another.

Overall, I vote for Custom Menus - real Windows type menus.

mx
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now