Clear Clipboard Contents Programmatically

[bsedabres]

Hi All. Just wondered if anyone knows how to clear the clipboard contents in Access 2000 through VBA. One of my forms is generating an error on close asking the user if they want to save the "large amount of data" on the clipboard. I thought there would be a
docmd.runcommand accmdclearclipboard option, but no luck.

Any help is be appreciated.

bas

 

[psemianonymous]

I'd recommend you "copy over" the clipboard by pasting new text there (i.e. "hi mom" or an empty string). I believe there are two methods to do this:

RunCommand acCmdCopy -- copies current field to the clipboard.


Clipboard API calls:

http://users.bigpond.net.au/abrowne1/func-07b.html

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[SBendBuckeye]

Bracket these around your DoCmd statement.

DoCmd.SetWarnings False
Your DoCmd statement
DoCmd.SetWarnings True

Good Luck!