A2007: Custom Menu problem

[Jim Gainsley]

We moved a database with a 10 button custom menu from A2003 where it ran
fine to A2007 where it hangs on everyone of the 10 buttons. No messages. We
did try the Analyze Macro tool and checked one of the buttons and got a
response which said to convert the macro to VB. But, NOT to convert it if it
was part of a custom menu, which it is. Anyone have any thoughts on how we
should proceed? (We are not overly familiar with Access, so we probably
will need a step by step solution,) We can access all of the tables and
other data in the database.

 

[Arvin Meyer [MVP]]

Try converting it to VB anyway. I'm guessing that your macros have security
permission problems. To open a form, the code needs to simply be something
like (aircode):

Sub cmdMyButton_Click()
On Error GoTo Error_Handler
DoCmd.OpenForm "Your form name"
Exit_Here:
Exit Sub
Error_Handler:
MsgBox Err.Number & ": " & Err.Description
End Sub

Without any error handling, you'll never get any reasonable cause for a
problem.