Moving records between tables in MS Access

  • Thread starter Thread starter adjacent
  • Start date Start date
Click For Summary
SUMMARY

This discussion focuses on transferring records between two tables in Microsoft Access based on a specific field value. The user aims to move records with the status "Done_s" from table A to table B whenever a change occurs. The solution involves utilizing Microsoft Visual Basic for Applications (VBA) to automate this process. The discussion highlights the need for a foundational understanding of VBA to implement the solution effectively.

PREREQUISITES
  • Familiarity with Microsoft Access 2019 interface and features
  • Basic understanding of Visual Basic for Applications (VBA)
  • Knowledge of table structures and field types in Access
  • Experience with event-driven programming concepts
NEXT STEPS
  • Learn how to write VBA scripts in Microsoft Access
  • Research how to use Access event triggers to automate record movement
  • Explore the Access DoCmd object for executing database actions
  • Study examples of data manipulation in Access using VBA
USEFUL FOR

This discussion is beneficial for database developers, data analysts, and anyone looking to automate record management in Microsoft Access using VBA.

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

Similar threads

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