Code to Print Screen ???

[Guest]

I would like to get the same result as...

<Alt><PrintScreen> (An Access Form)
Paste into Word or Excel, & then Print.

I have code to Print the Form Object, but
it doesn't always work.

Can this be done?

TIA - Bob

 

[Pringle9984]

It's been a long time since I've emulated key presses but try having
look at

http://msdn.microsoft.com/library/d...gapplicationsendingitkeystrokesvisualbasic.as

And just so you know the virtual key name for Alt is 'VK_MENU' an
print screen is 'VK_SNAPSHOT

 

[Guest]

Thank you. When I get this to work, after pressing
<Alt><PrintScreen>...I then Paste it into Excel &
Set the Print Area & then Print.

I'm not sure sending Keys from within Access will
do the Print.

Any other ideas??

TIA- Bob