Export Account Number To Clipboard

[mmatzke]

I need to copy data from one field to the clipboard allowing users to paste
in excel, as400, and other possible applications using a "control/V" option

field to copy: Forms![frmMainOpen]![frmMainSF01].Form![OrderNumber]

 

[Damon Heron]

Do u mean without highlighting the text and entering Ctl-C?

Damon

 

[mmatzke]

Correct - I know that sounds like an easier solution, but there is a reason
for this.
--
Mark Matzke

Do u mean without highlighting the text and entering Ctl-C?

Damon

I need to copy data from one field to the clipboard allowing users to paste
in excel, as400, and other possible applications using a "control/V"
option

field to copy: Forms![frmMainOpen]![frmMainSF01].Form![OrderNumber]

 

[Damon Heron]

Not knowing if your order number is entered onto the form?? where your order
number is located, but
this will copy the text into the clipboard. Some event has to trigger the
copy, I will let you figure that out.

Private Sub Text1_Exit(Cancel As Integer)
Me.Text1 = Me.Text1.Text
DoCmd.RunCommand acCmdCopy
End Sub

Damon

Correct - I know that sounds like an easier solution, but there is a
reason
for this.
--
Mark Matzke

Do u mean without highlighting the text and entering Ctl-C?

Damon

in
message news:[email protected]...

I need to copy data from one field to the clipboard allowing users to
paste
in excel, as400, and other possible applications using a "control/V"
option

field to copy: Forms![frmMainOpen]![frmMainSF01].Form![OrderNumber]

 

[Mr B]

Here is a link from the MVP web site that has multiple functions that handle
various clipboard functionality.

http://www.mvps.org/access/api/api0049.htm

Copy the entire code and past it into a new Module. Then you can use the
Double Click event of your text box where you want to copy the contents to
the clipboard and past the following code:

Dim strCurVal As String
strCurVal = Me.txtFromList
ClipBoard_SetText strCurVal

--
HTH

Mr B
askdoctoraccess dot com

Correct - I know that sounds like an easier solution, but there is a reason
for this.
--
Mark Matzke

Do u mean without highlighting the text and entering Ctl-C?

Damon

I need to copy data from one field to the clipboard allowing users to paste
in excel, as400, and other possible applications using a "control/V"
option

field to copy: Forms![frmMainOpen]![frmMainSF01].Form![OrderNumber]