I currently have a report that is produced into a new notepad file, which i then have to manually Select all then copy.
I was trying to use sendkeys to automatically transfer the report to the clipboard. but im strugling with the code. The comand to open the reprt is as follows:
DoCmd.OutputTo acOutputReport, "COA Data1", acFormatTXT, "qry1Txt.Txt", True
Sendkeys(^A^C)?? doesnt work
thanks
Jon
I was trying to use sendkeys to automatically transfer the report to the clipboard. but im strugling with the code. The comand to open the reprt is as follows:
DoCmd.OutputTo acOutputReport, "COA Data1", acFormatTXT, "qry1Txt.Txt", True
Sendkeys(^A^C)?? doesnt work

thanks
Jon