Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ridders52

    Control multiple monitor display using VBA

    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...
  2. ridders52

    Control multiple monitor display using VBA

    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...
  3. ridders52

    Control multiple monitor display using VBA

    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...
  4. ridders52

    Show web image in report

    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.
  5. ridders52

    Printing a web image in a report

    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...
  6. ridders52

    Show web image in report

    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...
  7. ridders52

    Printing a web image in a report

    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...
  8. ridders52

    Show web image in report

    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...
  9. ridders52

    Show web image in report

    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
  10. ridders52

    Show web image in report

    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...
  11. ridders52

    Control multiple monitor display using VBA

    Thanks strongm Busy today but will test this out in next couple of days and report back Colin
  12. ridders52

    Control multiple monitor display using VBA

    I've already checked which Windows & Access versions are in use by the client. That was done before starting this project.
  13. ridders52

    Control multiple monitor display using VBA

    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?
  14. ridders52

    Control multiple monitor display using VBA

    @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...
  15. ridders52

    Control multiple monitor display using VBA

    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...
  16. ridders52

    Control multiple monitor display using VBA

    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...

Part and Inventory Search

Back
Top