Thanks a lot.
I will try this
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>
wrote in message news:hEOvc.53062$Np3.2327545@ursa-nb00s0.nbnet.nb.ca...[color=blue]
> You can clear the ClipBoard in the Form's Unload event. The code in the
> sample below is placed behind a CommandButton but just copy it over to
> your Form's Unload event.
>
> ' Place these API declarations at the top of your Form in the General
> Declarations area.
> Private Declare Function OpenClipboard Lib "user32" (ByVal hWnd As Long)
> As Long
> Private Declare Function CloseClipboard Lib "user32" () As Long
> Private Declare Function EmptyClipboard Lib "user32" () As Long
>
>
> Private Sub cmdClip_Click()
> On Error GoTo Err_cmdClip_Click
>
> ' Open, Empty and Close Clipboard
> ' No Clipboard API error handling
> Call OpenClipboard(0&)
> EmptyClipboard
> CloseClipboard
> MsgBox "ClipBoard Cleared!"
>
>
> Exit_cmdClip_Click:
> Exit Sub
>
> Err_cmdClip_Click:
> MsgBox Err.Description
> Resume Exit_cmdClip_Click
>
> End Sub
>
>
> --
>
> HTH
> Stephen Lebans
>
http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Danny" <dannywork5@hotmail.com> wrote in message
> news:JeHvc.22$jI2.13214@news4.srv.hcvlny.cv.net...[color=green]
> > I am creatng a form and using wizard to automate some things.
> > I want the user to be able to Duplicate a record so I set this up[/color]
> behind a[color=green]
> > command button on the form. THe wizard did all the work.
> >
> > But I guess since it is using docmd commands which is basically a copy[/color]
> and[color=green]
> > paste from menu pull downs, I am getting a message asking me if I[/color]
> want to[color=green]
> > save or remove the stuff in the clipboard because it is a lot of data[/color]
> etc[color=green]
> > etc...
> >
> > Will this show up on the users machine when I send the mde?
> >
> > Thanks again
> > Danny
> >
> >[/color]
>[/color]
