Copy data only

[Guest]

I'm trying to copy using a Macro or any other way, data from a form to just
the clip board. My user wants to just hit a button and have just the data,
not the field names as well, be copied to a clipboard so he could paste it
into his calendar. I've created a macro that does runcommand - selectrecord
runcommand - paste but, that copies the field names as well. Is there any
way to do this?

 

[Douglas J. Steele]

I use the VBA in the attached KB articles to write to and read from the
clipboard:
http://support.microsoft.com/?id=138909
http://support.microsoft.com/?id=138910

 

[Guest]

Thanks Doug. I think I've seen you in here before. I took a look at those
articles and can create the module and procedure but, I'm not sure how to
inact it. I'm guessing I make a macro off of this module and then set the
macro to a button in Access?!?

 

[Douglas J. Steele]

No, I don't think you can use a macro. You'll have to use VBA.