Hi Andy
I've made a few minor changes to this DEMO database - version 2 attached if anyone is interested Multi Monitors v2.zip
1. On opening the db, the cursor is restricted to the active form & all buttons are disabled except Enable Cursor & Quit.
Clicking Enable Cursor also enables all...
Hi strongm
I've now managed to get this to work in a standard Access form and have effectively achieved my aim of disabling the secondary monitor
Unfortunately I haven’t managed to master the intricacies of the display settings API
Instead I’ve restricted the mouse to the active form window as...
Hi strongm
Just tested the code you provided using ClipCursor API
In a new form with just a single button, the cursor certainly disappeared BUT on both monitors so I couldn't click the button to release it again
However moving the mouse around and clicking repeatedly, the cursor reappears...
Yes the file is downloaded to the local computer and then loaded into the report or form.
However for the static Google maps I am using, it is instantaneous.
I also overwrite the same map.BMP file each time I change the postcode to avoid wasting disk space.
Apologies to @strongm.
Below is a copy of my own reply from my own thread (hopefully I can at least get that right!) [bigsmile]
======================================================================
It was late & I copied / pasted your code as you correctly pointed out.
Just to make things...
Apologies to @strongm.
It was late & I copied / pasted your code as you correctly pointed out.
Just to make things worse, I tried to be 'helpful' by also pasting in the other thread
OK - the alternative code I found (can't remember where or the author) is as follows:
Option Compare Database...
I had exactly the same problem with the supplied code.
I found this alternative code which worked perfectly for many online images
Option Compare Database
Option Explicit
Private Declare Function CLSIDFromString Lib "ole32" (ByVal lpstrCLSID As Long, lpCLSID As Any) As Long
Private Declare...
I have done some more research in this topic and found some alternative code:
Option Compare Database
Option Explicit
Private Declare Function CLSIDFromString Lib "ole32" (ByVal lpstrCLSID As Long, lpCLSID As Any) As Long
Private Declare Function OleLoadPicturePath Lib "oleaut32" (ByVal...
Oops
Thanks for the link to the VERY recent thread!
Exactly the same issue as me
Apologies for not doing a forum search first
I know I've followed strongm's instructions exactly
I'm using Access 2010 32-bit though I doubt that's relevant
Colin
I'm trying to include an online map for a UK postcode in an Access report.
I'd already tried using a web browser control exactly as I'd used in a form.
It doesn't work
Then I found this old thread via a Google search http://www.tek-tips.com/viewthread.cfm?qid=1758167
The solution by strongm...
Many thanks for the link strongm which I will investigate further
That's one I hadn't found with various google searches
Your suggestion of limiting the mouse to the primary monitor is another route to investigate
Do you have a link to any code for that as well?
@kjv1611
OK I accept that until I test it on a variety of setups I won't know for sure...
I'm not saying that APIs haven't changed.
However , one thing at a time
The first task is to see if I can get this to work on my Windows 10 dual monitor system.
If I can, then I'll test it on other...
Hi
Here's a detailed reply to you both...
@Andrzejek
It's a request from a client for a kiosk style database
For reasons of their own, they want a highly locked down database where users cannot 'escape' the database when it is open.
That's to overcome issues they've had in the past
Their users...
Hi
I have found various code to control multiple monitors displays e.g. using C# or VB
e.g. http://www.tek-tips.com/viewthread.cfm?qid=1669894
However, I want to do this using VBA in Access.
My goal is to disable the 2nd monitor programmatically
Ideally it would be 'Show Monitor 1 only' but...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.