Dwight/Tom, or any of you other smart guys (smarter than me anyway!) I am using Microsoft Access on a Pentium 4 1,6 Ghz, 384 Mb RAM machine with only 30% used hard drive space and up to date patches etc. Yet, when I tried to cut and paste from one table of Access and close that file to paste into another file the clipboard icon disappears after I close the source document. I can see the info in text on the clipboard but can't paste it into the new document. I've even tried to cut and paste only a single field just to see if it was a memory issue but even that wouldn't work. My virtual memory is set to automatic so shouldn't be an issue there either. I've also tried to cut and paste to excel and word with source open and then re-cut and paste but I get the string is too long message. I'm stumped, any ideas? Thanks in advance.

I just finished learning about ACCESS-2002! It's too complex! Too many hangups! Have U tried Crystal Reports !

Anyway as far as ACCESS is concerned use the Import Wizzard! Or File and Import! Don't cut and paste!

ivnj

I'm not familiar with Access (it is complex!) but I wonder if you've tried just dragging the section.

Open both the original document and the target document. You can use the "Tile" windows option by right clicking on your task-bar to get both visible, if necessary. Then highlight the portion you wish to copy over. Then drag it from the original file into the destination file.

If that doesn't work, you can also drag it to your desktop as a "scrap". Then open the destination file and drag the scrap into the document.

"Saving scraps for multiple uses

If there are specific portions of a file that you use repeatedly in a number of different applications or other files, such as a portion of a spreadsheet, a company logo, a signature, or a boilerplate paragraph, you can save them as scraps on your Desktop for quick access. To do so, open the file you'd like to create a scrap from. Select the item you'd like to copy as a scrap, and then drag it to the Desktop. As an alternative, you can copy the item and then paste it on the Desktop. When you do, a scrap file is created, which you can now drag or copy to other documents or applications. Please note that you can use this feature only if your program supports drag-and-drop functions for OLE (Object Linking and Embedding)". The indented paragraph from here.

Also, there is a very active "Access" users group that can provide much better information. You can access it (no pun intended) here.

When the page opens, click the "Desktop Applications" and look through the list.

(Note: if you see a reference to a "Microsoft VIP", that is a person with very specialized knowledge in the subject. These people are not employed by Microsoft, but they have a demonstrated expertise in the subject. If you see a Web link to one of these "VIP's" it is worth looking into. They often have better instructions and details about specific elements of the Office programs than does Microsoft. I have even gotten one-on-one assistance with "sticky" problems like this from some of them.)

I hope this helps!

Dwight

[This message was edited by Dwight on 01-14-03 at 03:25 AM.]

One final thought...

Reference your comment "one table of Access".

Are you trying to copy a table from one document to another? If that is the case, it may be that the destination table is of different dimensions that the original. For instance, if the original table is 5 rows with 3 columns, then the destination table would have to be the same.

If the file you're trying to copy into doesn't have a table in the area in which you want to paste the data, perhaps inserting a table with the same dimensions will make it work.

Anyway, I hope something here will be of some assistance.

Dwight

D-wight and ivnj, thanks for the responses. I figured it out on my own eventually. When in Access, you must completely shut down the database and Access itself before re-opening a new database to paste into. Once there, you must highlight the entire row for the clipboard icon to illuminate once again and then you can paste. Access is a little more difficult than most other programs in that you cannot run more than one database at a time. Appreciate the input, and good to see you again D-wight.