Unofficial Access Stuff

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Sunday, February 11, 2018 – Permalink –

Copy Access Data to New Records

Fewer steps

The Paste Append feature is often overlooked in Access.

This feature lets you quickly create new records that copy existing information from other records.

To see one way to use the feature, open a table in Datasheet view.

While holding down the [Shift] key, select adjacent fields with data you want to copy. You can also select fields from adjacent records.

When you've finished, press Ctrl+C to copy the data.

Then, choose Edit>Paste Append (Paste>Paste Append in 2007+)

Click Yes when Access asks for confirmation.

You'll now have an appropriate number of new records in the table that contains the information you copied.

See all Topics access
Labels: Entries, General, Reference, Shortcuts, Tips, Tutorials

<Doug Klippert@ 3:21 AM

Comments: Post a Comment