Windows 10 Camera

[priac]

How to I start the camera from Access. I have an Inventory program that uses pictures of the part. I would like to have a button to click that would start the Windows camera app.

 

[kjv1611]

Take a look at this where someone asked the same or similar question and found their own solution, posting back to the site:

https://stackoverflow.com/questions/28036527/open-windows-8-1-camera-app-with-vba

If anyone is interested I have found a work-around for this problem. I used this website to help create a Shortcut to the Camera App. I then used VBA to run the Shortcut. Works well enough for what I need to do! The code to run the link is as follows......

Dim MyFile As String 
Dim Cmd As String 
MyFile = "C:\Users\Name\Desktop\CameraTest.lnk" 
Cmd = "RunDLL32.EXE shell32.dll,ShellExec_RunDLL " 
Shell (Cmd & MyFile)

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[strongm]

Or, from at least W10 onwards:

CreateObject("WScript.Shell").Run "microsoft.windows.camera:"