VBA, Clearing the clipboard from Access

Andrew M. O'Brie
#1 / 7

Clearing the clipboard from Access

I'm using Office XP. I am using Word automation to create a document from
Access. In the process I put large images on the clipboard. Can anyone
tell me how to clear the clipboard from code in Access?

Thanks,
A

Thu, 14 Jul 2005 01:47:30 GMT

Doug Robbins - Word MV
#2 / 7

Clearing the clipboard from Access

Hi Andrew,

Better to post to an Access newsgroup

Please post any response to the newsgroups for the benefit of others who may
also be following the thread.

Hope this helps,
Doug Robbins - Word MVP

Quote:

> I'm using Office XP. I am using Word automation to create a document from
> Access. In the process I put large images on the clipboard. Can anyone
> tell me how to clear the clipboard from code in Access?

> Thanks,
> A

Thu, 14 Jul 2005 08:04:47 GMT

Tony Toew
#3 / 7

Clearing the clipboard from Access

Quote:

>I'm using Office XP. I am using Word automation to create a document from
>Access. In the process I put large images on the clipboard. Can anyone
>tell me how to clear the clipboard from code in Access?

I've seen some API calls to do this. Try searching at
support.microsoft.com for EmptyClipboard or KB article 138909.

However someone once mentioned a much simpler method using, I think,
Docmd or something similar but I don't recall any details and couldn't
find anything remotely close.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Sat, 16 Jul 2005 14:00:33 GMT

Malcolm Smit
#4 / 7

Clearing the clipboard from Access

Andrew

This may be of use:

http://www.dragondrop.com/WordCoding/word004.asp

Regards
Malc
www.dragondrop.com

Sat, 16 Jul 2005 19:35:31 GMT

Chirag Dala
#5 / 7

Clearing the clipboard from Access

Clear clipboard in Office:

---
Sub ClearClipboard()
CommandBars.FindControl(Id:=3634).Execute
End Sub
---

- Chirag
http://officerone.tripod.com/

Quote:

> I'm using Office XP. I am using Word automation to create a document
from
> Access. In the process I put large images on the clipboard. Can
anyone
> tell me how to clear the clipboard from code in Access?

> Thanks,
> A

Sat, 16 Jul 2005 20:40:51 GMT

S. Harr
#6 / 7

Clearing the clipboard from Access

You can use the following to copy and past items to/from the
clipboard:

DoCmd.RunCommand acCmdCopy (copies the currently selected
text)
DoCmd.RunCommand acCmdPaste

I'm unsure, but I think the below might clear the current clip board
contents. If not, you could always add an invisible textbox to your
form, then select the text it contains (which is nothing) and use the
above line (using the copy command) to copy this. This will happen
because the invisible text box will have the focus when you use the
line: "DoCmd.RunCommand acCmdCopy"

DoCmd.RunCommand acCmdClearAll

Lastly, you can select text in a text box by using the following
example:

txtListItemHTML.SetFocus
txtListItemHTML.SelStart = 0
txtListItemHTML.SelLength = Len(txtListItemHTML.Value)

Quote:

> I'm using Office XP. I am using Word automation to create a document from
> Access. In the process I put large images on the clipboard. Can anyone
> tell me how to clear the clipboard from code in Access?

> Thanks,
> A

Sat, 23 Jul 2005 06:15:41 GMT

Tony Toew
#7 / 7

Clearing the clipboard from Access

Quote:

>You can use the following to copy and past items to/from the
>clipboard:

> DoCmd.RunCommand acCmdCopy (copies the currently selected
>text)
> DoCmd.RunCommand acCmdPaste

That was it. Thanks, no wonder I couldn't remember or locate it. It
was off runcommand.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Tue, 26 Jul 2005 10:36:16 GMT