Bringing Access to foreground (1 Viewer)

eshai · Feb 13, 2019

hi:
i build a db for register student automatically
in first process it take a photo of the student
so i'm using windows camera app with "sendkeys" but it stucks in the front
i tried using "setforegroundwindow" like this code from here https://access-programmers.co.uk/forums/showthread.php?t=132129

but i get an error can't find dll entry point setforegroundwindow in user32
im using win 10 x64 and office 2016 x64 i add the "ptrsafe" to the code
can't find a way to bring access to the front. tried using "setfocus" "minimize"
"maximize" and other methods :banghead:

June7 · Feb 13, 2019

I faced a similar issue trying to coordinate Excel and Access. Needed the Excel to come to foreground. One of the reasons led me to eliminate Excel component which shouldn't have been there to begin with (inherited db mid-development).

Did you mean "ptrsafe"?

Very much doubt can do what you want.

eshai · Feb 13, 2019

ya sorry i ment "ptrsafe" for the declaration on x64 system

maybe "sendkeys" alt+tab well work just how to hold the Alt key?

eshai · Feb 13, 2019

It worked fine

Code:

sendkeys "%{TAB}"

June7 · Feb 13, 2019

How can Access code know when you have finished using the camera? Post your code.

Review
https://bytes.com/topic/access/answers/931097-wia-image-capture-windows-7-a
https://answers.microsoft.com/en-us...s-access/2f914df6-e83c-4e30-a305-f1aa2537e313

Okay, see you have found solution.

eshai · Feb 13, 2019

June7 said:
June7 said:

How can Access code know when you have finished using the camera? Post your code.

Click to expand...

it's very simple i used timer event to take a picture and to popup the next form
so 5 sec to take the picture (zoom etc') and more 2 sec for ending the process
of saving the file

Bringing Access to foreground (1 Viewer)

eshai

Registered User.

June7

AWF VIP

eshai

Registered User.

eshai

Registered User.

June7

AWF VIP

eshai

Registered User.

Similar threads

Users who are viewing this thread