Results 1 to 5 of 5
  1. #1
    maramadan is offline Novice
    Windows 7 32bit Access 2016
    Join Date
    Nov 2017
    Posts
    1

    how to use table level triggerd macros (After Update)

    Hello Access experts


    hope you are having a good day

    please help me with this
    I have two tables

    I want to make a date macro, when I make changes to table1.num1 changes reflect on table2 by creating new record
    TABLE1 have three fields ID, Name1, Num1
    TABLE2 have three fields ID, Name2, Num2
    the after update table macro lock like this in table1
    Click image for larger version. 

Name:	4.png 
Views:	12 
Size:	14.9 KB 
ID:	31336
    Click image for larger version. 

Name:	3.png 
Views:	12 
Size:	9.4 KB 
ID:	31335



    Why it is not working

    thanks

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    @ Bob,
    Might you have grabbed the wrong URL? The link you posted as cross posted is this thread URL......

  4. #4
    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
    Hi Steve,

    I think Bob meant this one
    https://access-programmers.co.uk/for...d.php?t=297048

    I see it was sorted out in the uk thread. I also note that maramadan has not returned to either.

  5. #5
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Thank you, Steve and Orange for sorting that out for me.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

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

Similar Threads

  1. Grade level table and subjects table
    By Khalil Handal in forum Access
    Replies: 4
    Last Post: 12-10-2016, 05:20 AM
  2. Linking Tables at the Table Level Vs. the Query Level
    By Tammy in forum Database Design
    Replies: 3
    Last Post: 12-03-2014, 01:34 PM
  3. Macros to update source data
    By sumera12 in forum Macros
    Replies: 2
    Last Post: 11-12-2014, 10:21 AM
  4. Table Level Validation
    By Stretch2312 in forum Access
    Replies: 4
    Last Post: 11-23-2012, 03:17 PM
  5. update team against 2nd level products
    By Lata in forum Queries
    Replies: 2
    Last Post: 09-20-2011, 03:35 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
  •  
Other Forums: Microsoft Office Forums