Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    11

    Unanswered: Dialog Box appears - Microsoft Office can't find the macro: Macro1

    My forms are working fine, I was previously trying to use macro, but was unsuccessful and have used VB instead.

    However, the following message appears in a dialog box:

    Microsoft Office can't find the macro: Macro1
    The macro (or its macro group does not exist), or the macro is new and has not been saved.
    Note that when you enter the macrogroupname.macroname syntex in an argument, you must specify the name the macro's macro group was last saved under.


    Any ideas as to where I would find the above, in VB, or properties or anywhere else.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Look for Macro1 in the Event Properties.

    This is one of the main reasons NOT to use macros. The event properties where Macro1 is specified could be those for the form, for the header, the footer or any label, textbox ... anything. You can't search for it, you have to go clicking everything to look for the event property with Macro1 in it.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Mar 2009
    Posts
    11

    Look for Macro1 in the Event Properties

    Your absolutely right. After spending a day and a half looking for this macro, I stumbled upon it accidently. It was part of the background, which incidently looks like any other form in design view. Will nevery use macros again. Many thanks for your reply. Have a nice day.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You're most welcome; glad you are over macros now Anything macros can do, VBA can do better... and with class
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •