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]

Re: Capturing Forms

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

"Andi" <caduceus@postm aster.co.uk> wrote in message
news:42c959ca$0 $12924$cc9e4d1f @news.dial.pipe x.com...[color=blue]
> 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[/color]
uses[color=blue]
> graphs and tables that are dynamically created) into Word documents to[/color]
form[color=blue]
> 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[/color]
if[color=blue]
> 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[/color]
received.[color=blue]
>
> Regards, and thanks in advance of any assistance,
>
> Andi
>
>[/color]

[Andi]

Re: Capturing Forms

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 " <macdermott@NoS pam.com> wrote in message
news:%23ygbOuNg FHA.2916@TK2MSF TNGP14.phx.gbl. ..[color=blue]
> Lost you on the "applicatio ns can't accept that".
> Could you elaborate?
>
> "Andi" <caduceus@postm aster.co.uk> wrote in message
> news:42c959ca$0 $12924$cc9e4d1f @news.dial.pipe x.com...[color=green]
> > Greetings all,
> >
> > I have recently created a database that functions as an inventory[/color][/color]
analysis[color=blue][color=green]
> > 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[/color]
> uses[color=green]
> > graphs and tables that are dynamically created) into Word documents to[/color]
> form[color=green]
> > part of financial submission documents. The most obvious method to do[/color][/color]
this[color=blue][color=green]
> > would be to take a screenshot and paste it into Word, but I was[/color][/color]
wondering[color=blue]
> if[color=green]
> > there was an easier, automated way of doing this. I have checked out[/color][/color]
the[color=blue][color=green]
> > use of SendKeys to print screen, but applications can't accept that,[/color][/color]
which[color=blue][color=green]
> > leaves me at a dead end.
> >
> > Any suggestions, or advice you could give would be most gratefully[/color]
> received.[color=green]
> >
> > Regards, and thanks in advance of any assistance,
> >
> > Andi
> >
> >[/color]
>
>[/color]

[MacDermott]

Re: Capturing Forms

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" <caduceus@postm aster.co.uk> wrote in message
news:42c9a74b$0 $12901$cc9e4d1f @news.dial.pipe x.com...[color=blue]
> When using the command SendKeys "{PRTSC}" nothing happens. According to
>
>[/color]
http://msdn.microsoft.com/library/de...thsendkeys.asp[color=blue]
>
> applications can't accept the Print Screen key from SendKeys.
>
> "MacDermott " <macdermott@NoS pam.com> wrote in message
> news:%23ygbOuNg FHA.2916@TK2MSF TNGP14.phx.gbl. ..[color=green]
> > Lost you on the "applicatio ns can't accept that".
> > Could you elaborate?
> >
> > "Andi" <caduceus@postm aster.co.uk> wrote in message
> > news:42c959ca$0 $12924$cc9e4d1f @news.dial.pipe x.com...[color=darkred]
> > > Greetings all,
> > >
> > > I have recently created a database that functions as an inventory[/color][/color]
> analysis[color=green][color=darkred]
> > > tool for the department I work in. Recently, there has been a user
> > > requirement to have functionality to export images of the main form[/color][/color][/color]
(it[color=blue][color=green]
> > uses[color=darkred]
> > > graphs and tables that are dynamically created) into Word documents to[/color]
> > form[color=darkred]
> > > part of financial submission documents. The most obvious method to do[/color][/color]
> this[color=green][color=darkred]
> > > would be to take a screenshot and paste it into Word, but I was[/color][/color]
> wondering[color=green]
> > if[color=darkred]
> > > there was an easier, automated way of doing this. I have checked out[/color][/color]
> the[color=green][color=darkred]
> > > use of SendKeys to print screen, but applications can't accept that,[/color][/color]
> which[color=green][color=darkred]
> > > leaves me at a dead end.
> > >
> > > Any suggestions, or advice you could give would be most gratefully[/color]
> > received.[color=darkred]
> > >
> > > Regards, and thanks in advance of any assistance,
> > >
> > > Andi
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]