Copy entire form to clipboard (1 Viewer)

[PhilC]

Hello Guys,

Having worked for years with most Ms Office products, I have reached an impasse with Ms Access. For the first time ever, I want to copy the screen image of a form using VBA. Preferably from within the form itself once it is active. My aim is to use the image on a website. I do not wish to add the whole database to the website as other data is private, . I have tried umpteen routes and even considered venturing down the SharePoint route, but lots of expense for such a simple issue seems excessive. Any ideas please all gratefully received.

Thanks

 

[Uncle Gizmo]

Why not use the built in Snip & Sketch Tool supplied with windows?

 

[arnelgp]

here is a demo.

 

[PhilC]

Thanks both arnelgp and Uncle Gizmo.

I had thought of Snip & Sketch, but not pursued the idea. If I could find the exe file I could use Shell command to launch it programmatically. But finding the exe file has proved a nightmare. Can anyone tell me the path?

Many thanks

 

[arnelgp]

its in:

C:\Program Files\WindowsApps\Microsoft.ScreenSketch_11.2109.37.0_x64__8wekyb3d8bbwe\ScreenSketch.exe

you must Takeownership of the folder in order for you to view the files inside.

 

[Pat Hartman]

@PhilC What was wrong with arnel's sample? Did you even try it?

 

[PhilC]

Yes, but cannot get access to the snip and sketch executable. Microsoft have hidden it and I need to get access through a chain of folders and subfolders. I welcome any quick solution. The Take Ownership option is greyed out and I cannot find the subfolders that Arnel specified.

 

[Gasman]

Yes, but cannot get access to the snip and sketch executable. Microsoft have hidden it and I need to get access through a chain of folders and subfolders. I welcome any quick solution. The Take Ownership option is greyed out and I cannot find the subfolders that Arnel specified.

Well you will need to go searching?, starting as far in as WindowsApps?

Mine on this computer is C:\Program Files\WindowsApps\Microsoft.ScreenSketch_2020.814.2355.0_neutral_~_8wekyb3d8bbwe but I do not have an exe in there


However is demo worked for me?

I cannot yet find a screensketch.exe

 

[theDBguy]

Hi. Take a look here and see if it helps or gives you any ideas.

Access Crash Reporter – The Smiley Coder

 

[Gasman]

My exe is actually in C:\Program Files\WindowsApps\Microsoft.ScreenSketch_10.2008.2277.0_x86__8wekyb3d8bbwe