Capturing Forms

[Andi]

Greetings all,

I have recently created a database that functions as an inventory analysis
tool for the department I work in. Recently, there has been a user
requirement to have functionality to export images of the main form (it uses
graphs and tables that are dynamically created) into Word documents to form
part of financial submission documents. The most obvious method to do this
would be to take a screenshot and paste it into Word, but I was wondering if
there was an easier, automated way of doing this. I have checked out the
use of SendKeys to print screen, but applications can't accept that, which
leaves me at a dead end.

Any suggestions, or advice you could give would be most gratefully received.

Regards, and thanks in advance of any assistance,

Andi

 

[MacDermott]

Lost you on the "applications can't accept that".
Could you elaborate?

 

[Andi]

When using the command SendKeys "{PRTSC}" nothing happens. According to

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/wsmthsendkeys.asp

applications can't accept the Print Screen key from SendKeys.

 

[MacDermott]

Try the code here:
http://www.devx.com/vb2themax/Tip/18341
Although it's written for VB6.0 and earlier, I think it should all work fine
in VBA (Access).