By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,374 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Copy (or Append) a record to a different table in Access 2007

P: 52
I've been searching archives, but I can't find anything I can make work, and this is probably really simple--unfortunatley just not for me. I want to have a button on a form that when clicked will copy (or append) the current record (from the table "Auction Items 2009") to a different table ("Auction Items"). I can make the button, but I can't seem to figure out what code to use. A macro would be fine, but while it says macros can execute a command on the ribbon, I can't find a way to do that. I would appreciate any help.
Apr 6 '10 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Having identical records in multiple tables is a major violation of normalization ruls! Why do you feel the need to do this?

Linq ;0)>
Apr 6 '10 #2

P: 52
The record won't always stay identical. I'm tracking donations for a silent auction, and I create a new table each year. The item they donate can different, and sometimes the name of the contact, the address or phone can change, and not everyone donates again. I copy the record from the previous year and update fields as necessary, but by having the previous years we can always look back to see what they have donated over the years.
Apr 7 '10 #3

P: 52
I think I missed the correct way to respond before. Please see my response above.
Apr 8 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.