troubleshooting Question

Menu Macro ‘Action Failed’, Access 2003

Avatar of mlcktmguy
mlcktmguyFlag for United States of America asked on
Microsoft Access
7 Comments1 Solution169 ViewsLast Modified:
I got an unexpected error report (twice) today from a user of a long running, stable application. By stable I mean three years full time every day with 40 – 50 users.  No changes were made recently, especially to this area.

I’ve been developing in Access for over 15 years and never encountered this situation.  I used the application specific ‘Main_Menu’ as the Menu Bar on all of the forms in my other applications also.

This application is split and each user has their own copy of the application on their machine, all linked to the backend Access MDB
The macro that failed was ‘Main_Menu’.  This menu appears at the top of all of the forms in this application.  It is defined as the ‘Menu Bar’ on all of these forms.

It failed loading ‘Reports_menu’.
Macro FailureThe failure appeared as soon as the application tried to open the form.

About this Macro
Main Menu has 4 ’AddMenu’ rows, each adding another menu macro.  File_Menu, Action Menu, Reports_Menu and Admin_Menu in that order.
File Menu contains only 1 ‘RunCommand’ row, ‘Exit’.
Action Menu contains 4 rows, 3 ‘RunCodes’ and 1 RunMacro.
Reports_Menu has 5 ‘RunCode’ lines.
Admin_Menu has 27 ‘RunCode’ lines.

I am at a loss as to what could cause this issue, especially twice on one user machine in the same day but not any of the other 49 machines using the Main_menu macro for the last three years.

Any help would be greatly appreciated.

I am providing as much detail as possible but if more is need to resolve this issue please let me know.
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros