DataObject in Access?

[Bob Bridges]

I'm trying to modify some already-existing VBA/Access code to put some text
in the clipboard. Now, in Excel I just create a DataObject and use its
built-in methods SetText and PutInClipboard; it's very simple. But when I
try that in Access, I can't seem to create the object. Is there something
obvious I'm missing? The appropriate object library is checked, and the VBA
editor is properly capitalized "dataobject", so apparently it can see it.
Yet I'm not allowed to "Dim cb As New DataObject" nor to "Set cb = New
DataObject"; it says I'm not allowed to use "New" in that context, though it
works fine in Excel. What secret words must I utter to get it to work?
Anyone know?

 

[Tom van Stiphout]

On Tue, 19 Jan 2010 21:33:01 -0800, Bob Bridges

I'm not sure - you kept the library name secret which makes it
difficult for us to help you.
Here is an alternative method (actually, two):
http://www.mvps.org/access/api/api0049.htm

-Tom.
Microsoft Access MVP

 

[Daniel Pineault]

see http://www.mvps.org/access/api/api0049.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.