Question about VBA

By omnknt232006 ·
I have this access 2003 Database that I have been asked to cleanup and make ready for a production environment. The previous programmer failed to use any standard naming conventions and left almost no comments in the coding but that is a different story.
My question is this. This particular DB has a main item table that keeps all the records and also has a new item table for data entry. Both are navigated by the users through the use of a form. I am new to VB programming and a relatively new to complex databases. I was wondering what is the best way to copy all the records from the new item table and insert them into the main item table then delete all the records in the new item table.
Thanks for any help anyone can give.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums