Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Access 2010 copy & paste?
Worksheets originally designed in Access in Office 2000. I used to be able just to filter and select the records I wanted then copy and paste them over to another worksheet where I could delete unwanted details and merge with a mail merge letter. With Access 2010 I can filter and copy the records and supposedly get them on the clipboard but cant seem to get both worksheets showing at the same time and Access 2010 wants to close the first sheet down before opening the second thereby cancelling out the copied records...I'm sure I'm just being ultra stoopid but I'm tearing my hair out here.
Thanks for your response. I have already managed to save the filtered data to a second sheet within the workbook - what I need to do now is copy and paste this into another workbook. Access 2010 closes the first workbook before opening the second one and it would appear that data saved on the clipboard of the first workbook is also closed and no longer available to paste to a second workbook and doesn't allow for both workbooks to be opened at the same time. Oh boy...
Hi Again, Just to let you know - I've done it. Following your advice I formed a second worksheet with the filtered files and pointed to that as the data needed for the Merge document - it worked - Thank you.
1 Answer
- 1 decade agoFavorite Answer
Create a new table in ur existing database . Then ur current data (table ) and new table will be showed up in two different tab but in a single database . U can copy -paste easily . And later u can save that database according ur need .Will that help ?
