I'm sure it is possible, but how would I run an SQL statement in VBA that copies the results to the clipboard rather than populate the results in a query or table? I am assuming I'll be using DAO in this case.
I'm sure it is possible, but how would I run an SQL statement in VBA that copies the results to the clipboard rather than populate the results in a query or table? I am assuming I'll be using DAO in this case.
Please tell us more or show us your proposed SQL
""run an SQL statement in VBA that copies the results to the clipboard
I have no SQL typed up atm. But I do know that you can copy the recordset in excel and paste it.
before you send everyone off to do your research for you, have tried googling something along the lines of 'copy recordset to clipboard'
If you can do it in excel then I would think it is doable in access - what code would you use?
Is this what you're after?
https://www.pcreview.co.uk/threads/c...board.2772619/
Cheers,
Vlad
I did do research, but found no results regarding my specific question. I always do as much research as I can before posting to avoid wasting anyone's time.
This will work. I can dissect each function. Thanks. I am probably going to void out "ms access" in future searches to expand results.