Search results

I currently use the following code on a button to publish a number of fields into a single textbox and then copy this text to the clipboard Me.txtExportText = vbCrLf _ & Me![Combo55] _ & vbCrLf & Me! [List33_Label] & ": " & Me! [List33] _...

Hi dean, i am having the same problem when exporting report to text file, did u ever find an answer? thanks Jon

the aim of the report publishing in notepad is to produce a suituable format for data to be cut n pasted into an external programme. e.g: Data entry form: Name Address; Telephone: Etc (SUBMIT - containing the below code) No records are saved. Just published in notepad. DoCmd.OutputTo...

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...

I currently use the following comand to produce a report from an imput form. this report is opened in a new text file in note pad. I use the following comand: DoCmd.OutputTo acOutputReport, "REPORT NAME", acFormatTXT, "Doc1.txt", True 'open in Notepad Is there anyway, when this data gets...

Any ideas guys?! I use the following code on the PUBLISH BUTTON at the mo. DoCmd.OutputTo acOutputReport, "REPORT NAME", acFormatTXT, "Doc1.txt", True 'open in Notepad I then cut n paste the text from notepad to the clipboard. ANyway of publishing direct to the clipboard?

thanks rural guy, but that one only copies individual fields in a form. Anyone know of anyway to publish the report into the clipboard? in the same way that the report can be published into a .txt. doc? thanks again. joN

Thats a great help! one more point though, as i am very poor at access... How do i implement this 'openarg' on the switchboard's properties? or for the button to open the details form? how do i code it? thanks for you help so far! jon

How do i implement this global variable? sorry im pretty new to this. just in simple terms relating to my example above if possible. then hopefully i can apply this to my db! thanks again! Jon

Hi, i am having problems copying one data field from one form to another. I would like users to type in their user number in the switchboard and then this number to prepopulate the other sub forms. i have enclosed and example, any help would be greatly apreciated. thanks, Jon

thanks for the quick reply gizmo, i dont think that method will work in my case however as i am looking for the complete formatted report to be published to the clipboard :(

Hi, I have a data entry form in access used to create a suitable format for copying into an external system. Currently, i have a button which publishes the report in a new wordpad file, which at the moment,i cut and paste manually into the external system. I was wondering if it was possible to...