473,413 Members | 2,056 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,413 software developers and data experts.

Need Clarification Regarding Copy, Paste, Delete Function ?

can we do copy/paste/delete multiple cells in Access 2013 as in Excel.

{NeoPa}A separate question was split off to Need Clarification Regarding Undo and Redo{/NeoPa}
Jul 15 '14 #1
5 1316
twinnyfo
3,653 Expert Mod 2GB
There is no undo capability for MS Access, as records in database tables don't work that way.

Also, since Access tables differ greatly from MS Excel Spreadsheets, they do not have "cells" in the traditional sense of the word. They have "fields" in "records" in "tables".

All that aside, it is possible to delete values from a table. However, without additional detail, it is impossible to provide any additional guidance.
Jul 15 '14 #2
Ya I am talking about Fileds in every record. I can able to copy,paste,delete single Filed.Is that possible to copy,delete mutilple same fields in different records .
Jul 16 '14 #3
twinnyfo
3,653 Expert Mod 2GB
You will have to provide a better description of what you want to do. I know it is possible to do all those things, but I don't quite understand your question.
Jul 16 '14 #4



in the attached image can we do copy , paste and delete multiple names (ex:john,alex barry) at the same time under student name's column . If yes ,how can we do that .
becoz I can able to copy or delete one name at single time.
Jul 17 '14 #5
NeoPa
32,556 Expert Mod 16PB
You can actually copy and paste multiple cells from one grid to another in Access. However, to do so the correct shape of cells must first be selected. This can cover fields in a record; A field across multiple records; or even multiple fields across multiple records. It's not as flexible as Excel and won't duplicate for you (EG. You cannot copy one set of fields and duplicate the same data across many records, as you can in Excel.) but with the proper understanding you can copy vast amounts of data from one grid to another in Access, or even to Access from Excel. Using Excel, you can prepare the data you want with many clever tricks and then Copy/Paste it across to an Access grid.

NB. Selecting a cell in Access is no the same as selecting the data in the cell. Only when the background of the cell is all highlighted is the cell selected. Otherwise only the contents are selected.
Jul 17 '14 #6

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

Similar topics

4
by: The Flyer | last post by:
Hi Sorry for posting this message to so many groups, but I was not sure which group the windows keyboard experts would be reading, so I ventured to post it to all of them. I want to map or...
4
by: Legendary Pansy | last post by:
I was checking out the 101 C# Samples, specifically Windows Forms - Use the Clipboard. I took a look at the code for a while, and I understand what the program is doing with the cut, copy, pasting...
2
by: Mansi | last post by:
I'm trying to automate excel from c#. One of the things I need to do is to copy/paste/insert rows in excel via c# code. I tried to do the following: 1) Select a row in excel (a12 to k12) 2)...
2
by: Max81 | last post by:
Im trying to build a calculator for an assignment! (due wednesday) im having trouble finding any code for creating Copy/Paste menu buttons (just need the "doing" code) can anyone help? in...
1
by: Kuups | last post by:
Hi! I have a question is there any way of disabling the Copy, Paste, Delete ? of a Windows Control Tex Box Right Click Property during runtime ? Thanks!
7
by: lgbjr | last post by:
Hello All, I¡¯m using a context menu associated with some pictureboxes to provide copy/paste functionality. Copying the image to the clipboard was easy. But pasting an image from the clipboard...
8
by: serge calderara | last post by:
Dear all, I have an treeview control with different node object, I would like to implement the Copy/Paste function of an object . For that I am using the folowing function to copy teh object to...
2
by: al_johnson222 | last post by:
>From any page, I want to be able to call a JS function that will do the equivelant of select all, and copy. This data will then be posted to a page that will log it. This would be easy using...
8
by: jh | last post by:
I'd like to copy/paste into a listbox during runtime. I can do this for a textbox but can't figure out how to accomplish this for a listbox. Any help? Thanks.
3
by: Shepard | last post by:
Hi guys, I am developing an application which takes consumer_id from our employees and searches them from database if consumer_id match is found his details are available... Now I have managed to...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.