This seems like it should be so simple, but it aint... lol or maybe I am just jet lagged...
I have a Ms Acess 2003 chart object 'chtAIRN' I have a cmd button on the form called cmdCopy. I want users to be able to click the button and it copies the chart object into cach so that they can use the chart in other locations such as word and powerpoint.
I have tried a few options but nothing seems to work. I know users can select the chart then select copy from the edit menu, but I want to make it even easier for users.
The other option is to send the image to a jpg file on the desktop.
Any help is greatly appreciated.