Share via

Cannot run the macro or callback function error message...

Anonymous
2013-06-25T19:29:34+00:00

I recently converted from Access 2003 to 2010. I have created my own customized ribbon as well. The problem is that I keep getting an error message stating: "XXX cannot run the macro or callback function "forms_mac.frmSecurity". Make sure the macro or function exists and takes the correct parameters." I don't know why I'm gettin this message. I'm trying to click on the button in the menu I created and have a form generate. I'm wondering if this needs to be an onCommand instead of onAction? I haven't touched any of the macros and in the other databases I've converted I haven't had to do anything with the existing macros either. Below is my XML data:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

<ribbon startFromScratch="true">

<tabs>

<tab id="TabForms" label="Forms">

<group id="GroupStructure" label="Structure">

<menu id="MenuStructure" label="Structure" itemSize="normal">

<button id="MenuButton1" label="User Profiles"

onAction="forms_mac.frmSecurity" />

<button id="MenuButton2" label="Admin Types"

onAction="forms_mac.frmAdminTypes" />

<button id="MenuButton3" label="Business Types"

onAction="forms_mac.frmBusType" />

<button id="MenuButton4" label="Fund Types"

onAction="forms_mac.frmFundType" />

<button id="MenuButton5" label="Rates"

onAction="forms_mac.frmRates" />

</menu>

</group>

<group id="GroupData" label="Data">

<menu id="MenuData" label="Data" itemSize="normal">

<menu id="MyMenuNextLevel1" label="Interim">

<button id="MenuButton6" label="Groups"

onAction="forms_mac.frmGroupWrk" />

<button id="MenuButton7" label="Division Names"

onAction="forms_mac.frmDivision" />

</menu>

<menu id="MyMenuNextLevel2" label="Production">

<button id="MenuButton8" label="Groups"

onAction="forms_mac.frmGrpUtils" />

</menu>

</menu>

</group>

<group id="GroupProcesses" label="Processes">

<menu id="MenuProcesses" label="Processes">

<menu id="MyMenuNextLevel3" label="Claims">

<button id="MenuButton9" label="Import Claims"

onAction="processes.CLMIMP" />

<button id="MenuButton10" label="Append Claims"

onAction="processes.CLMAAP" />

<button id="MenuButton11" label="Remove Period"

onAction="processes.REMCLM" />

</menu>

<menu id="MyMenuNextLevel4" label="Counts">

<button id="MenuButton12" label="Import Counts"

onAction="processes.CNTIMP" />

<button id="MenuButton13" label="Append Counts"

onAction="processes.CNTAPP" />

<button id="MenuButton14" label="Remove Period"

onAction="processes.REMCNT" />

</menu>

</menu>

</group>

<group id="GroupGroups" label="Groups">

<menu id="MenuGroups" label="Groups">

<button id="MenuButton15" label="Import Groups"

onAction="processes.GRPIMP" />

<button id="MenuButton16" label="Process Groups"

onAction="processes.GRPPROC" />

</menu>

</group>

<group id="GroupDivisionNames" label="Division Names">

<menu id="MenuDivisionNames" label="Division Names">

<button id="MenuButton17" label="Import Division Names"

onAction="processes.DIVIMP" />

<button id="MenuButton18" label="Update Division Names"

onAction="processes.DIVAPP" />

</menu>

</group>

<group id="GroupReports" label="Reports">

<button id="MenuButton19" label="Load Reporting Data"

onAction="processes.RPTDATA" />

</group>

</tab>

</tabs>

</ribbon>

</customUI>

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2013-06-25T21:19:28+00:00

    No "onAction" is the correct value. 

    Are you trying to call a forms macro?  I think it has to be a Global macro.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2013-06-26T15:48:18+00:00

    I would just get a global macro to run 1st.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2013-06-26T13:51:23+00:00

    My other databases I've used:

    onAction="forms_mac.frmUsers" as you can tell from the XML data. What I noticed yesterday after i posted this question is that the forms I'm trying to open is not set up in the macro. So, I tried setting them up back that is not working either. I'm going to do a few more tests within the macro and see if I can get something to work. I'll touch back in a bit. One more question tho, should I create a group macro and just list the separate forms that I want to open?

    Was this answer helpful?

    0 comments No comments