barrie
Mar 15th, 2000, 02:12 AM
The goal:
Using the right mouse button the user will be able to copy data from various columns of a multi-column listbox to the Windows clipboard so he/she can paste them to another document.
The problem:
I'm using VBA in Access 97. I am uncertain what version of VB Access 97 uses (I think it's 5.0), but regardless of the version it apparently does not recognize the Clipboard object, so the Clipboard's "get" and "put" methods are unavailable. I can extract the data from the listbox with no problem; however, placing it on the clipboard without a reference to Clipboard object is posing a significant difficulty. Also, as the final resting place for the data is unknown (might be Word, might be Notepad, might be anything) I can not use anything internal to Access to store it (such as a global variable), nor can I set up a function to paste it (the user will need to be able to use Windows' default "CTRL-V" or right-click-paste).
Does anyone have any ideas? I am certain there has to be an API call that will do it, but I have been unsuccessful in finding it.
Using the right mouse button the user will be able to copy data from various columns of a multi-column listbox to the Windows clipboard so he/she can paste them to another document.
The problem:
I'm using VBA in Access 97. I am uncertain what version of VB Access 97 uses (I think it's 5.0), but regardless of the version it apparently does not recognize the Clipboard object, so the Clipboard's "get" and "put" methods are unavailable. I can extract the data from the listbox with no problem; however, placing it on the clipboard without a reference to Clipboard object is posing a significant difficulty. Also, as the final resting place for the data is unknown (might be Word, might be Notepad, might be anything) I can not use anything internal to Access to store it (such as a global variable), nor can I set up a function to paste it (the user will need to be able to use Windows' default "CTRL-V" or right-click-paste).
Does anyone have any ideas? I am certain there has to be an API call that will do it, but I have been unsuccessful in finding it.