Results 1 to 2 of 2
  1. #1
    SunTop is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Aug 2016
    Posts
    93

    copy macro code

    hello everyone,

    I am trying to create and audit trail for my database, I am following this tutorial on this link

    https://scottgem.wordpress.com/2012/10/18/audit-trail-using-data-macros-2/


    I was able to follow along and it worked for a single field, but when I reached this paragraph:

    "To place an Audit Trail on other fields, you can collapse the If and then copy and paste to add another set. Change the fieldname information as needed."



    I was not able to copy the macro and paste it, when I paste the macro it pastes inside the previous if statement, the only time I get the right menu to appear is when I click inside the previous statement, when I click on the white space below it, I don't get the right menu to choose pate form it

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See the info in this link -it includes a sample database with audit log.

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

Similar Threads

  1. Ho to create a copy and paste macro
    By George F in forum Macros
    Replies: 9
    Last Post: 02-26-2018, 10:02 AM
  2. btn macro what can copy text to clipboard
    By TriFith in forum Import/Export Data
    Replies: 6
    Last Post: 07-01-2016, 02:45 AM
  3. Macro to copy and paste
    By chr1stoper1 in forum Macros
    Replies: 2
    Last Post: 04-11-2016, 06:51 AM
  4. Simple macro to copy fields
    By Jay Pee in forum Macros
    Replies: 9
    Last Post: 03-14-2014, 06:52 AM
  5. Replies: 2
    Last Post: 06-06-2011, 04:18 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