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

Copying a field to multiple fields

P: 7
Access 2003 - Is there any way to copy/drag data from one field to multiple fields in the same column?
Nov 16 '06 #1
Share this Question
Share on Google+
5 Replies


nico5038
Expert 2.5K+
P: 3,072
Not without code that I know.
For multiple fields the "Access" way will be to create an UPDATE query, or when you store the data in a linked Excel sheet you can do the trick there...

Why the need ?

Nic;o)
Nov 16 '06 #2

P: 7
Thanks for your response. I have never been able to figure out how to do this, I think because if will only copy and then paste to the same exact number of fields. I do this alot in dbs where I have people who meet the same criteria for something, e.g. state, so It would be nice to be able to copy and paste it for all rather than for each one.

thanks again
Nov 16 '06 #3

nico5038
Expert 2.5K+
P: 3,072
Might be interesting then to check the sample from the Access CookBook:
9.5 Carry Data Forward from Record to Record
It's description is found at:
http://www.oreilly.com/catalog/accesscook2/
And following the "examples" link and selecting CDROM will allow you to download the Chapter 9 samples. 09-05.mdb will be the one to inspect.

This way a user can carry forward the fields needed when entering the data.

Nic;o)
Nov 16 '06 #4

P: 7
Thanks, I read that and realized I guess I wasn't specific.

I am using a table only, not a form, it seems like that language is referring to a form with a toggle button.

thanks, helpless
Nov 16 '06 #5

NeoPa
Expert Mod 15k+
P: 31,186
You can't Copy/Paste from one record to many, but you can copy a set number of entries for the same field(s) then paste them to the same number of records elsewhere.
Not ideal, but can save some time.
Using Excel to enter a single value into multiple cells (Ctrl-Enter) and then Copy/Pasting across to Access can also work.
Nov 17 '06 #6

Post your reply

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