Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    Helen's Avatar
    Helen is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2009
    Location
    The Hill, Australia
    Posts
    28
    Have no idea what was doing it - there was no problem for a year, until I included the data-check sub last week, and it continued even if the call to that was commented out. Hence the head-scratching.



    I know it's just a patch for when it happens, but it's all I have time for right now.

  2. #17
    Helen's Avatar
    Helen is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jan 2009
    Location
    The Hill, Australia
    Posts
    28
    I was happy enough to get the 'rough as guts' version done using raw numbers for the location of the mouse (Access on full-screen & the form where it opened) but today, I've succeeded in improving that a WHOLE LOT!

    I've learned about twips (never heard of them before).
    Instead of bare numbers for the boundaries of a correct mouse location onscreen, I now have them based on where the control is positioned within the section --- where the section (eg detail) is positioned on the form --- and where the form is located onscreen - and it takes into account the screen resolution as well. All locations in twips, relative to the screen.

    Tested to death by moving & resizing Access & the same for the form within, and it WORKS!

    I sigh with relief.

    If anyone needs the details of getting the various locations - happy to share the info, but didn't think it worth posting all the code. Send me a PM if you need the details.

  3. #18
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Thanks for the update Helen. Good news too.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Probably a Strange thing to ask
    By everette in forum Access
    Replies: 3
    Last Post: 03-26-2011, 08:33 PM
  2. Auto sort a form when opened?
    By newtoAccess in forum Access
    Replies: 2
    Last Post: 03-19-2011, 03:22 PM
  3. Can not close pop up form after second pop was opened
    By snoopy2003 in forum Programming
    Replies: 2
    Last Post: 03-09-2011, 02:56 AM
  4. A Little bit strange...
    By Maverick1501 in forum Access
    Replies: 0
    Last Post: 03-29-2010, 09:59 AM
  5. Replies: 6
    Last Post: 03-17-2010, 10:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums