Question Exporting a snapshot? (1 Viewer)

[ericryd]

Hello,

I've been researching but haven't found this yet. I'm looking for a way when I click a button, a screenshot or snapshot is taken and saved to a specific file location. Anyone have any thoughts?

 

[JamesMcS]

Have a look in the help file about the sendkeys macro action. I would use this to send alt-print screen, then open paint or other image program, paste, save and close - all within a macro.

 

[ghudson]

I advise against using SendKeys.

You can easily print a form. This is what I use to print a screen shot of the current record in a form...

    Printer.RightMargin = 0.25
    Printer.LeftMargin = 0.25
    Printer.Orientation = acPRORLandscape
    DoCmd.RunCommand acCmdSelectRecord 
    DoCmd.PrintOut acSelection

 

[JamesMcS]

Apologies, I read "screen shot" and thought that's what the OP was after.

 

[ericryd]

Have a look in the help file about the sendkeys macro action. I would use this to send alt-print screen, then open paint or other image program, paste, save and close - all within a macro.

This sounds like what i'm looking for. Any other info on how to do it? I understand the concept, but its the underneath code that i'm not sure what to do with

 

[ghudson]

Irfanview allows command line options. That might work for you www.Irfanview.com if you call it from Access.

 

[JamesMcS]

I haven't actually used it, just read about it - I'd have a google if I were you, but I do know that after you've sent the alt-print screen, you could also use "shell" to run MS paint, then another sendkeys to paste it in, and another to save. Syntax wise, who knows??

Home time! If you get stuck, PM me over the weekend and we'll sort on Monday.

J