Suppressing clipboard message

[jgarnick]

I have a command button that selects all the data from a form, copies it to the clipboard and pastes it to the table (This is done to copy a record already in the table). The process works fine except when I close the form, I get the Access message about copying a large amount of data to the clipboard, do I want to save it? It does not matter whether you say yes or no, since the data has already been pasted. Is there a way to suppress that message or get around having the user have to answer it?
Below is the code behind the button--

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append

Thanks!
[sig]<p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br> [/sig]

 

[THoey]

I don't have time to try to set it up, but did you try to use the &quot;DoCmd.SetWarnings False&quot; before the above listed code and then the &quot;DoCmd.SetWarnings True&quot;?

Hope that helps...
[sig]<p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?[/sig]

 

[jgarnick]

Thanks Terry--setting the warnings off works, but I can't figure where to set them back on--I tried after the above code, and I tried when closing the form, but the clipboard message comes up. It's a matter of timing, I guess. If I just leave the warnings off, it works fine. I'll play some more.....who needs warnings anyways! Thanks so much-- [sig]<p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br> [/sig]