By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Capturing Forms

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Lost you on the "applications can't accept that".
Could you elaborate?

"Andi" <ca******@postmaster.co.uk> wrote in message
news:42***********************@news.dial.pipex.com ...
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

Nov 13 '05 #2

P: n/a
When using the command SendKeys "{PRTSC}" nothing happens. According to

http://msdn.microsoft.com/library/de...thsendkeys.asp

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

"MacDermott" <ma********@NoSpam.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
Lost you on the "applications can't accept that".
Could you elaborate?

"Andi" <ca******@postmaster.co.uk> wrote in message
news:42***********************@news.dial.pipex.com ...
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


Nov 13 '05 #3

P: n/a
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).

"Andi" <ca******@postmaster.co.uk> wrote in message
news:42***********************@news.dial.pipex.com ...
When using the command SendKeys "{PRTSC}" nothing happens. According to

http://msdn.microsoft.com/library/de...thsendkeys.asp
applications can't accept the Print Screen key from SendKeys.

"MacDermott" <ma********@NoSpam.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
Lost you on the "applications can't accept that".
Could you elaborate?

"Andi" <ca******@postmaster.co.uk> wrote in message
news:42***********************@news.dial.pipex.com ...
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



Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.