Results 1 to 6 of 6
  1. #1
    warmslime is offline Advanced Beginner
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    49

    Data macro - OnError action has no Macro Name option

    Hey guys,


    I'm trying to build an AfterInsert data macro and the OnError action has no Macro Name option! It only has Next and Fail.

    Is this standard behavior? According to my textbook, Macro Name should have been there!
    Attached Thumbnails Attached Thumbnails Καταγραφή.PNG  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Yes, an error can only do 2 things,
    stop
    or move on.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Not sure about 2013 but certainly up to 2010 macros don't have error handling beyond the basics of stop or keep going. You need to use VBA for more sophisticated error handling

  4. #4
    warmslime is offline Advanced Beginner
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    49
    Oh okay, thanks guys. I guess my textbook is wrong then. You can close this thread if you want...

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    You can close this thread if you want...
    you can - click on thread tools to the right of the green ar at the top of the thread

  6. #6
    warmslime is offline Advanced Beginner
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    49
    Sorry to bump an old thread but I'd liek to clarify (for other people that were looking for the same thing) that you there is a Macro name option in normal Macros - it's only data macros that don't have it.

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

Similar Threads

  1. Using the SendKeys action in a Macro
    By john134 in forum Programming
    Replies: 5
    Last Post: 05-27-2014, 01:54 PM
  2. SetValue Macro action
    By rkalapura in forum Programming
    Replies: 3
    Last Post: 12-19-2011, 11:54 AM
  3. PrintOut Macro Action
    By EHittner in forum Access
    Replies: 1
    Last Post: 09-22-2011, 01:27 AM
  4. Macro Action
    By Bakar in forum Forms
    Replies: 1
    Last Post: 01-05-2011, 12:38 PM
  5. conditional macro action
    By frcastro in forum Programming
    Replies: 4
    Last Post: 06-27-2010, 10:59 PM

Posting Permissions

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