The Access object model does not expose the HWnd property of the
Application.


"G-Force" <GForce@discussions.microsoft.com> wrote in message
news:1C67973F-B16A-442C-AAE2-5BBC310B6062@microsoft.com...
> When I compile the code below (in Access 2003) I get an error
> at this line :
>
> OpenClipboard Application.hwnd
>
> The error I get is "method or data member not found"
>
> What is causing this ????????
>
> "RB Smissaert" wrote:
>
>> Sorry, that should be:
>>
>> Option Explicit
>> 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
>>
>> Sub ClearClipboard()
>> OpenClipboard Application.hwnd
>> EmptyClipboard
>> CloseClipboard
>> End Sub
>>
>> The clipboard has to be opened first and then closed after
>> clearing it.
>>
>> RBS
>>
>>
>>
>> "Reuel" <Reuel@discussions.microsoft.com> wrote in message
>> news:C6DA21DE-9995-4F27-B576-D52A15FF3BF4@microsoft.com...
>> > Is there any way to clear the clipboard in a macro run? I've
>> > been having
>> > strange programmatic freezes after a long series of
>> > cut/paste/select
>> > operations (see previous post by me) and I thought that it
>> > might help
>> > force a
>> > clear of the clipboard periodically.
>> >
>> > Also, can anyone suggest another resource for help when no
>> > one inthis
>> > forum
>> > has a suggestion for solving Excel programming problems?
>> > Thanks,
>> >
>>
>>