Access Vba Table copy question

S

socom36252

Joined
Jul 22, 2013
Messages
1
Reaction score
0
I have a form that looks up an ID in a table. If the ID is there it allows the user to continue the form else i output an error. What im trying to do is if the ID is correct and the operator finishes the form when they click submit i want the fields in the row of the ID chosen to be copied to a new "history table" then deleted from the "current table" Then the "current table" updated with the new ID information. it is important we have a history table to be able to look back and see what changes have been done to these IDs. Again this is in VBA using access.
 

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

Pop-up form that creates record that links 1:1 to main form 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to export table from outlook into ms access table? 0
question about visual basic and microsoft access 1
VBA Multiple Line handling with Split() 1
Access Passing the value to a table 1
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Access Loop a datamacro in Access 2010 using vba code 0

Top