Why is the "copy" command disabled when viewing a query in Access?

W

Wes

I recently upgraded to Access 2003 from XP. I want to copy and paste a query
result to Excel. But the "copy" and "cut" commands are disabled in the main
menu, the tool bar, and the context menu. Any idea why?
 
J

John Vinson

I recently upgraded to Access 2003 from XP. I want to copy and paste a query
result to Excel. But the "copy" and "cut" commands are disabled in the main
menu, the tool bar, and the context menu. Any idea why?
Click to expand...

Not sure, but in any case I'd suggest a different approach: File...
Export, and select Files Of Type to be .xls.

John W. Vinson[MVP]
 
V

Van T. Dinh

Even in Access 2002, you need to have some rows or some text selected before
the Copy command becomes enabled.

If you want to just copy the entire Datasheet of the Query, you can use
Tools / Office Links / Analyze it with Excel or alternatively File / Export
....

HTH
Van T. Dinh
MVP (Access)
 
W

Wes

Yes, I know, I did that frequently in Access XP. I didn't want to use the
export because I want to copy the data into a specific location in an
existing spreadsheet that I update every month and that has a bunch of
analysis linked to it.

I think the problem is related to another error that I got later in Excel,
"Cannot empty the clipboard" which prevented me from copying or cutting
there. After I exited all of my Office applications and restarted Access, I
was able to copy, but this seems like a bug of some kind.
 
V

Van T. Dinh

In this case, you should really automate it from Access using VBA. Excel
has the Method CopyFromRecordset which should fit your requirement
perfectly.

Check Excel VBA Help on CopyFromRecordset Method.
 
Top