Dear all,

I have a problem....

Using Office 2000 at the moment, and therefore having to work with VBA as against VB. I'm trying to develop a toolbar button for use in Access for capturing screen shots of the database and saving them directly to a file on disc.

I'm trying to avoid the hassle of using the 'PrintScrn' key, and opening Paint, then pasting in the clipboard image, then having to find a location to save the image, then save it.

What I'd like to do is click the button, be presented with the common dialog box for file open/save with a name already suggested and save the file.

I've managed to get to the stage of getting the image to the clipboard, and I have a module for the common file open/save dialog box, but what I can't figure out how to do is save the clipboard to a file on disk. There's no Clipboard object in VBA so everything would have to be done via the APIs.

Can anyone help out?

Regards,

Ian J.