• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Data macro to update date from one table to another in access (1 Viewer)

saledo2000

Registered User.
Local time
Today, 17:48
Joined
Jan 21, 2013
Messages
94
Hello,
Is it possible to create Named Data Macro to update date from one table to another on open database. I will put that Named Data Macro to Autoexec macro to execute update. Can you please help with this because I do not have big experience in access.
Thank you.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:48
Joined
Oct 29, 2018
Messages
12,532
Hi. If you want the macro to execute when the db opens, then you don't even need to use a data macro. A UI macro should be enough.
 

Ranman256

Registered User.
Local time
Today, 13:48
Joined
Apr 9, 2015
Messages
3,623
make an append query,
put it in a macro,
have it run at a button click on a form by a user.
 

Users who are viewing this thread

Top Bottom