Using Access 2007, Fully Patched as of 02/07/2009

In VBA, is there a way to copy the value of a string variable to the windows
clipboard?

"CrazyAccessProgrammer" <(E-Mail Removed)>
wrote in message news:68D91C1E-4085-458F-B753-(E-Mail Removed)...
> Using Access 2007, Fully Patched as of 02/07/2009
>
> In VBA, is there a way to copy the value of a string variable to the
> windows
> clipboard?

For a control, you can go:

Me.Notes.SetFocus
DoCmd.RunCommand acCmdCopy


for a variable, you can use the following api:

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


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)

Thank you so much.

"Albert D. Kallal" wrote:

> "CrazyAccessProgrammer" <(E-Mail Removed)>
> wrote in message news:68D91C1E-4085-458F-B753-(E-Mail Removed)...
> > Using Access 2007, Fully Patched as of 02/07/2009
> >
> > In VBA, is there a way to copy the value of a string variable to the
> > windows
> > clipboard?
>
> For a control, you can go:
>
> Me.Notes.SetFocus
> DoCmd.RunCommand acCmdCopy
>
>
> for a variable, you can use the following api:
>
> http://www.mvps.org/access/api/api0049.htm
>
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> (E-Mail Removed)
>
>
>
>
>