Pasting into a range

[Guest]

Hi, and thanks for your help in advance.

Is it possible to paste into a range, within the same column, of sequential
records?

I'm trying to select 10-20 cells within a field and paste the same value at
once. Shift/select allows me to select the cells, but the paste command only
pastes the value into the top-most field. I'm in datasheet view.

-R

 

[strive4peace]

if you create the records first, then select the column of data (press
F2 to toggle between insertion point and select whole field) -- or
specific fields if you want to limit it to a range, you can press CTRL-C
in Excel (for instance) then CTRL-V in Access

what is the purpose for doing this?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Thanks, Crystal. I'm trying to change values manually, based on a visual
assesment of my db. I'm working in a 300,000 row flat-file that has sales,
customers, customer industries, etc. Occasionally I need to change a value in
15-20 fields (within a single column) at once. Using find/replace is slower
than pasting, but I can't figure out how to do the paste operation into more
than 1 field at a time.

Example: I need to change a customer's industry from retail to wholesale.
I'd just like to select all fields in the 'industry' column for that customer
and paste the new, correct industry. In Excel I would select the correct
cells and paste. In Access...?

Thanks,

R

 

[strive4peace]

Hi R (what is your name?)

Another way to do this, if the records are one after another:

paste into the first one, down-arrow to next and press CTRL-", and so on
(ctrl-ditto copies value from field above)

if you have several to do, copy the field, go to a query window you have
already set up to update that field, paste the copied field into the
criteria, and change the UpdateOt cell

"I need to change a customer's industry from retail to wholesale. I'd
just like to select all fields in the 'industry' column for that
Customer and paste the new, correct industry."

.... but, sorry to say, it sounds like you need to normalize your tables

download and read this:

Access Basics
http://allenbrowne.com/tips.html
Tips for Casual Users
Access Basics: free tutorial - Word document by Crystal (Access MVP)


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[John W. Vinson]

Example: I need to change a customer's industry from retail to wholesale.
I'd just like to select all fields in the 'industry' column for that customer
and paste the new, correct industry. In Excel I would select the correct
cells and paste. In Access...?

In Access, you'ld move your data into a properly normalized set of tables and
update the one (ONLY ONE!!) Customer record.

Just because Access *can* work with spreadsheets - single big flat files -
doesn't mean that it's a good idea!

Read Crystal's reference document. You'll find Access works a lot better if
you work with it, as a relational database, rather than trying to force it to
be "Excel on steroids".

John W. Vinson [MVP]

 

[strive4peace]

Hi John,

"Excel on steroids"

.... interesting term


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*