I currently am designing a template programe which mainly uses MS access as a front end system to get information into the correct format using the ms access report . The report currently outputs to a notepad file.
This outputed report (in notepad) is then copied and pasted manually, at the moment, by the user into external 3rd party software. I am desperate to see if it is possible to somehow copy the outputted text, in its outputed report format, to the clipboard without having to go through the copy/paste stage from notepad.
An example form is as follows:
Caller name:
Caller number:
Acc number:
OLd address:
New Address:
(Submit BUTTON) - No records are saved in the database. Just published in notepad in correct format. Using the below code:
DoCmd.OutputTo acOutputReport, "COA Data1", acFormatTXT, "qry1Txt.Txt", True
The form is then cleared, ready for the user to submit the next change of address.
Is it possible to somehow copy the information directly to clipboard by publishing the report to a unbound text file on the form window itself? and then use the standard copy comand to copy to clipboard? any idea how i might do this?
im in a serious pickle with this one, any help would be greatly apreciated!
thanks,
Jon
Start Free Trial
