Code needed to move data between tables

R

RockNRoll

Access VBA Wizards,

I have another challenge ahead of me.

I have to create some code that will loop through each record in my
"tbl_Receipts" table and transfer the data in one of it's fields to another
table and date stamp it when I run the code.

I truly appreciate your assistance.

Regards,

-Dave
 
C

Craig

Well you have 2 options on how to do this. Either via an
append query or by using code by opening 2 tabledefs and
copying the data over from one tabledef to the other.

--Craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Adding data to MS Access from csv file 0
Need Help with a VBA subroutine 0
importing data 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
VBA - (re-) Set a Table Style 2
Macro: VBA code to move/forward email based on subjects and attachments 0
Getting Radio Buttons to work, that are inserted via AutoText 0

Top