Moving records between tables in MS Access

  • Thread starter Thread starter adjacent
  • Start date Start date
AI Thread Summary
In Microsoft Access, it is possible to automate the transfer of records between two tables based on a specific field value. To move records with the status "Done_s" from table A to table B whenever a change occurs, Visual Basic for Applications (VBA) can be utilized. This involves writing a VBA script that triggers on data changes, checking the status field, and executing an INSERT operation to transfer the relevant records. For beginners, resources such as functionx.com provide valuable tutorials on using VBA in Access, making it easier to learn and implement these functionalities.
adjacent
Gold Member
Messages
1,552
Reaction score
62
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.
 
Computer science news on Phys.org

Thread 'Google DeepMind, AI/ML and ALPHA-fold'

I came across a video regarding the use of AI/ML to work through complex datasets to determine complicated protein structures. It is a promising and beneficial use of AI/ML. AlphaFold - The Most Useful Thing AI Has Ever Done https://www.ebi.ac.uk/training/online/courses/alphafold/an-introductory-guide-to-its-strengths-and-limitations/what-is-alphafold/ https://en.wikipedia.org/wiki/AlphaFold https://deepmind.google/about/ Edit/update: The AlphaFold article in Nature John Jumper...
View full post »
Thread 'Urgent: Physically repair - or bypass - power button on Asus laptop'

Thread 'Urgent: Physically repair - or bypass - power button on Asus laptop'

Asus Vivobook S14 flip. The power button is wrecked. Unable to turn it on AT ALL. We can get into how and why it got wrecked later, but suffice to say a kitchen knife was involved: These buttons do want to NOT come off, not like other lappies, where they can snap in and out. And they sure don't go back on. So, in the absence of a longer-term solution that might involve a replacement, is there any way I can activate the power button, like with a paperclip or wire or something? It looks...
View full post »

Similar threads

On-hold Audio recording change on tempo
Replies
8
Views
2K
Comp Sci Optimizing Hash Table Storage for Efficient Record Retrieval
Replies
4
Views
2K
Design of interrupt handling hardware circuit for a real time scenario
Replies
19
Views
2K
Dashcam is leaving file artifacts on SD card
Replies
35
Views
4K
Spreadsheet help: compare two lists to find exceptions
Replies
41
Views
5K
Compare and/or combine two Access database tables
Replies
5
Views
4K
Modern Digital Audio: Understanding Dither and Oversampling in Hi-Res Age
Replies
17
Views
4K
Functional Dependence (In Table/General)
Replies
3
Views
2K
A Chat with ChatGPT: Peerless Intelligence
Replies
3
Views
3K
MODEM Question -- Can a factory reset & re-register clear up intermittent drops?
Replies
8
Views
3K

Hot Threads

Recent Insights

Back
Top