Results 1 to 7 of 7

Macro Error

  1. #1
    UT227 is offline Competent Performer
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    269

    Macro Error

    I'm getting this error:


    Click image for larger version. 

Name:	error1.jpg 
Views:	11 
Size:	12.5 KB 
ID:	33558
    Click image for larger version. 

Name:	error2.jpg 
Views:	11 
Size:	34.3 KB 
ID:	33559

    Strange thing is that I don't remember putting in a macro. I've looked all over the form and subforms for that macro. I can't find it. Is there a way Access can tell me where it is?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    18,023
    Looks like a button named Command74, which is opening another form.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  3. #3
    UT227 is offline Competent Performer
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    269
    The problem is that I can't find it

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    18,023
    I would have guessed you clicked on it to get the error. With the form in design view, open the properties window. In the dropdown at the top, select the command button; it should now be selected on the form. If you still can't find it, attach the db here if you can.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  5. #5
    UT227 is offline Competent Performer
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    269
    I wish it was that easy. I have a series of update and append queries to go through to add information. When I go back to the form, it gives me that error. Which sounds like it would be in the On Activate or On load. I don't have an embedded macro there. I have an event procedure. I've looked through each part of the form, and subforms. I can't find a macro with Command 74.

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    18,023
    Can you attach the db here?
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  7. #7
    UT227 is offline Competent Performer
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    269
    I'll have to take out a whole lot to get it out. I'm going to try something first. I may have something left over from revising it so much.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Macro can't run. No error pop out.
    By fluffyvampirekitten in forum Access
    Replies: 4
    Last Post: 08-12-2015, 05:50 PM
  2. Replies: 1
    Last Post: 01-13-2015, 12:33 PM
  3. Macro Error
    By enquiries in forum Access
    Replies: 6
    Last Post: 04-16-2014, 09:44 PM
  4. Macro Error
    By Randy in forum Access
    Replies: 2
    Last Post: 01-28-2013, 09:32 AM
  5. Replies: 2
    Last Post: 05-05-2012, 01:34 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums