Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Moving records between tables in MS Access

  1. Jul 7, 2014 #1

    adjacent

    User Avatar
    Gold Member

    I have two tables(a and b) in one access document. And in each table, I have a field[called status](look up field) having the options "Done" and "Done_s".
    What I want to do is move the records having the [status] "Done_s" to b. This should be done whenever the change occurs. Is this possible?

    I never used access before and google also does not provide an answer to this.
     
  2. jcsd
  3. Jul 8, 2014 #2
    You can use the built in Microsoft Visual Basic.
    Lesson 1, what better place to start.
    http://www.functionx.com/vbaccess/index.htm
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted
Similar Discussions: Moving records between tables in MS Access
  1. Recording sounds (Replies: 2)

  2. Recording a webcam (Replies: 2)

  3. MS Access (Replies: 2)

Loading...