bschickert
New member
- Local time
- Today, 18:45
- Joined
- Feb 27, 2012
- Messages
- 1
I have a database with over 2 Million records. I need to do 2 things that I just can't figure out. Hopefully someone smarter than me can help!
I need a button, that when pressed will copy certain fields of the record being viewed (in form view) and paste them into a different database or even another table in the current DB (however this would then be redundant data).
This will be used by MS Word as the source for a mail merge to complete a form letter...
In my main DB I have many fields, but I only need Account #, First Name, Last Name, Address, Address2, Address3, City, State and zip to be pulled out. (of the current record... not the entire table, don't want to end up with a list of 2 million people.....)
Gotta be a simple way. I have tried all that I know (took like 10 minutes!!!), well maybe a little longer but I need some help from someone who can really lead me through this. Thanks in advance for any of your help and time.
I need a button, that when pressed will copy certain fields of the record being viewed (in form view) and paste them into a different database or even another table in the current DB (however this would then be redundant data).
This will be used by MS Word as the source for a mail merge to complete a form letter...
In my main DB I have many fields, but I only need Account #, First Name, Last Name, Address, Address2, Address3, City, State and zip to be pulled out. (of the current record... not the entire table, don't want to end up with a list of 2 million people.....)
Gotta be a simple way. I have tried all that I know (took like 10 minutes!!!), well maybe a little longer but I need some help from someone who can really lead me through this. Thanks in advance for any of your help and time.
