By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,289 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,289 IT Pros & Developers. It's quick & easy.

How to avoid clip board message when duplicating record

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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


Nov 13 '05 #2

P: n/a
Thanks a lot.
I will try this

"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:hE*********************@ursa-nb00s0.nbnet.nb.ca...
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.