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" <da********@hotmail.com> wrote in message
news:Je****************@news4.srv.hcvlny.cv.net...
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
behind a 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
and paste from menu pull downs, I am getting a message asking me if I
want to save or remove the stuff in the clipboard because it is a lot of data
etc etc...
Will this show up on the users machine when I send the mde?
Thanks again
Danny