How do you clear the clipboard in VBA ? 3

[BuilderSpec]

Well that's it really.. copying and pasting a record that is big, when I come out of the form it keeps asking me if I want to keep the data on the clipboard ? I don't but i don't want it to ask me every time. Is there not some code that I can run that will clear the clipboard before I leave the form?

Regards

BuilderSpec

 

[PHV]

Have you tried to copy empty stuff in the clipboard before leaving the form ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[kayek]

Did you or anyone find a resolution to this problem. I am having the same problem.

 

[CajunCenturion]

Have you tried using the EmptyClipboard API?

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[BuilderSpec]

No cajun... how does that work ?

 

[CajunCenturion]

First thing you need to do is to declare the following APIs in the declarations section of a Code Module.

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

Then, from inside some method of your form, execute the following three lines of code.

OpenClipboard Me.hwnd
EmptyClipboard
CloseClipboard

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[CajunCenturion]

One update, change the "Private" to "Public" in the three API declarations.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[BuilderSpec]

Cheers I will try it and if it works ur a gem !