Easy copying of blank cell in column to cell below

[Guest]

I know you can cut and paste one data in a column to a blank cell below it.
How can you copy a single item like "tag number" to multiple blank lines in
records below it in the same column below it, without doing it one line at a
time. Access cut and paste only seems to work on one "copied item" to a
single blank cell below it.

 

[Guest]

You can copy multiple records to multiple records by highlighting the data,
copying, then highlighting the target records and pasting.

 

[John W. Vinson]

I know you can cut and paste one data in a column to a blank cell below it.
How can you copy a single item like "tag number" to multiple blank lines in
records below it in the same column below it, without doing it one line at a
time. Access cut and paste only seems to work on one "copied item" to a
single blank cell below it.

ummm....

Access is NOT a spreadsheet. It doesn't have "cells". You should not be
working in table datasheets in any case - they are not designed for data
interaction but rather for data storage!

Also, it's almost never a good idea to have the same value repeated in
multiple otherwise blank records. What is the structure of your table? What's
a "tag number" and why do you need it repeatedly? Might you be able to use a
one (tag) to many (other data) relationship, using a form with a subform?

John W. Vinson [MVP]

 

[Guest]

Sorry, not copying records, but a specific data listing in one "cell" in
dataview record. The answer through other means, is using the apostophe and
control key. That allows one to copy the "cell" above it? Thanks though.

 

[Guest]

I know it is not excel.. But in the dataview , whether a query or a table.
the data is still in columns and cells. The answer I found in other means,
is by using the control key and the apostophe. It copies any data in the
"cell" or whatever you want to call it to the blank cell below it.. For
example if tag number was title of one column headings and in that first cell
was AT701. for the 2nd and continuous records, if you use the control and
apos. key, the tag AT701 repeats itself. Keep hitting the cont. and apos
key, and go down in the column is much faster than a cut and past one line at
a time. Though thanks for your repsonse.

 

[Guest]

You can copy and paste as many records and fields of those records as you
want following what I posted. Just make sure you highlight matching records
and fields for the target area. You can highlight more for pasting than was
copied and it will not overwrite the extra like Excel does.

 

[John W. Vinson]

I know it is not excel.. But in the dataview , whether a query or a table.
the data is still in columns and cells. The answer I found in other means,
is by using the control key and the apostophe. It copies any data in the
"cell" or whatever you want to call it to the blank cell below it.. For
example if tag number was title of one column headings and in that first cell
was AT701. for the 2nd and continuous records, if you use the control and
apos. key, the tag AT701 repeats itself. Keep hitting the cont. and apos
key, and go down in the column is much faster than a cut and past one line at
a time. Though thanks for your repsonse.

Apologies for the didacticism. I'd call it a "field" not a cell.

In a Form (not in a table or query datasheet though; it can be a form in
datasheet view) you can put VBA code in the AfterUpdate event of a textbox:

Private Sub txtboxname_AfterUpdate()
Me!txtboxname.DefaultValue = """" & Me!txtboxname & """"
End Sub

to set the default value of a field to the most recent entry.

John W. Vinson [MVP]