473,545 Members | 2,013 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need Clarification Regarding Copy, Paste, Delete Function ?

13 New Member
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 1328
twinnyfo
3,653 Recognized Expert Moderator Specialist
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
ESAKKI109
13 New Member
Ya I am talking about Fileds in every record. I can able to copy,paste,dele te single Filed.Is that possible to copy,delete mutilple same fields in different records .
Jul 16 '14 #3
twinnyfo
3,653 Recognized Expert Moderator Specialist
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
ESAKKI109
13 New Member



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,563 Recognized Expert Moderator MVP
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
27704
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 create shortcut on the keyboard for Cut/Copy/Paste functions. I can use the regular Control_X, C or V to do the same in Windows XP, but I would rather...
4
21595
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 via the file menu events using the clipboard. However, what I don't get is how is the program able to produce a context menu in the textbox area. When...
2
35206
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) Insert a row. 3) copy contents of a12 to k12. 4) Paste these contents to new row. The "Record Macro" function returns the following code:
2
1551
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 addition, how do you get the keyboard numbers to activate the "calculator" buttons. (not as important)
1
1111
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
11606
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 is proving to be more difficult. These pictureboxes are bound to an AccessDB. If the user wants to add an image, they select an image using an...
8
2600
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 clipboard : ====> Private Sub CopyToClipboard(ByVal Obj As PluginApp.PlugInReport) ' Creates a new data format.
2
4438
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 copy/paste functionality but I don't want to screw-up users copy/paste buffer. Anyone have an example of how to retrieve all text with similar...
8
15397
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
2282
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 validate the text field to numeric only..ie: It will accept numbers only..If anyone presses alphabets or special characters it wil not type in the...
0
7660
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7431
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7761
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5976
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5337
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3457
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1888
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1020
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
709
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.