Register to reply

Moving records between tables in MS Access

by adjacent
Tags: access, moving, records, tables
Share this thread:
adjacent
#1
Jul7-14, 01:09 PM
PF Gold
adjacent's Avatar
P: 1,489
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.
Phys.Org News Partner Science news on Phys.org
Fungus deadly to AIDS patients found to grow on trees
Canola genome sequence reveals evolutionary 'love triangle'
Scientists uncover clues to role of magnetism in iron-based superconductors
256bits
#2
Jul8-14, 02:33 PM
P: 1,475
You can use the built in Microsoft Visual Basic.
Lesson 1, what better place to start.
http://www.functionx.com/vbaccess/index.htm


Register to reply

Related Discussions
Records and C++ Engineering, Comp Sci, & Technology Homework 3
Compare and/or combine two Access database tables Computers 5
Academic Records, Expunged Academic Guidance 6
Fortran: help with I/O in Direct Access and Seq. access Programming & Computer Science 0
Filtering/Displaying records from Access in Visual Studio 2008 Programming & Computer Science 1