Automatic copy

[bgcogen]

I ned Access to automatically copy th
entire contents of a query onto the clip board when that query is opened. Is this possible??
Thanks

 

[ColinEssex]

I'm intrigued as to why you need to do this

Col

 

[bgcogen]

Well, basically I need to do it because I've to perform calculations in excel and have to paste the contents to a Sheet1 in an existing Spreadsheet, and I don't want the user to have to highlight all the records and paste each time.

 

[ColinEssex]

You can export data to Excel using the TransferSpreadsheet action. See Access help for the method

Col