Copy & Paste

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have a large database that 6 users share. They would like to be
able to copy data from one cell to multiple cells, is there an easy way of
doing this? e.g. In excel they would drag the field to copy the contents,
this is what they would like to do in Access.
I have setup the database but I am only a basic user. Your help would be
appreciated.
 
When using a datasheet, you can copy the contents of the "cell" above by
using Ctrl+". That's the Control key plust the double-quote key. Then use
the down arrow to move down. This works in Excel too.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Before you encourage this type of activity, you should discuss with your
users why they want to duplicate data. One of the benefits that Access
provides over Excel is the ability to put data in one time and use it in
many places. A properly structured database will typically not contain
duplicate rows.

If your users want to avoid rekeying some data you should look into lookup
fields and drop down lists
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying & pasting forms 2
Excel Data pastes into 2 cells not 1 1
Restricting User Access In Access 2010 Sharepoint With Hydrated Database 0
Copy current record to report form 2
Copy and Paste Between Databases 1
Invisible Formulas / Copying 2
How to copy curtain data fields from excel to access table via VBA 2
Copy and paste in Exel and Word 1

Back
Top