Page 2 of 2 FirstFirst 12
Results 16 to 26 of 26
  1. #16
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    Quote Originally Posted by Welshgasman View Post
    Colin. I mentioned it as the tracker form in your CERT DB does not resize correctly for me, as I have to scroll down to get the horizontal scrollbar.


    Yet when I amended the display to 100% the resize worked as it should.

    However with my eyesight these days, I need the 125%
    OK. You have a specially adapted version of my CERT app for A2007 again using an old version of the resizing code.
    I think I know the reason but will need to check
    Rather than hijack the OP's thread further, please can you email me attaching a screenshot of the tracker form together with your resolution info & approx screen size
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  2. #17
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,819
    Quote Originally Posted by isladogs View Post
    OK. You have a specially adapted version of my CERT app for A2007 again using an old version of the resizing code.
    I think I know the reason but will need to check
    Rather than hijack the OP's thread further, please can you email me attaching a screenshot of the tracker form together with your resolution info & approx screen size
    Will do. Thank you.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #18
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Eish, thank you. I went to bed 4 am this side. Slept well, so will box on for the next 16 hours. Just replaced the 9 modules with the newest. All seem well checking out your files. My app flashes the content of any form now then all content disappears, only background left.

  4. #19
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    Forgot to mention - you also need to import tblMonitors to your app as that is used to save details about your monitor size & resolution
    Close your app & reopen.
    Hopefully then OK
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #20
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    All seem well now. Can't thank you enough.
    a. If settings in modResizeform is 800 X 600 my forms display contents much larger that the screen.
    b. If I set it to 1360 X 768, same as my windows setting, then it looks perfect.
    c. I first reduced a form width to 30cm, but not filling up the screen.
    d. I reduced from 38cm to 36 cm, and it seems perfect.
    e. I hope it will fit most screen sizes now. I have to adjust more than 100 of my forms manually now.


    Click image for larger version. 

Name:	221128a.png 
Views:	26 
Size:	23.2 KB 
ID:	49216

  6. #21
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    There are several template forms supplied with my example app.
    One of them is for 1366x768 which is almost identical to your chosen resolution so you could use it as a guide.
    That suggests a form width = 34.485cm & total height of 17.201cm in design view

    Click image for larger version. 

Name:	Capture.jpg 
Views:	25 
Size:	93.9 KB 
ID:	49217

    Sorry the image is so big!

    BTW I've just tested the new version at 2400 x 1350 on a 12-inch tablet and it works perfectly
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #22
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    @Preface

    Thank you for all the likes/ rep points. If you have found this useful, perhaps you would be willing to write a testimonial for my website. See Testimonials (isladogs.co.uk)
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #23
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Hi Colin. Today I experienced the following.
    a. When the table or query has no records, the form shows no empty fields.
    b. If I remove "ReSizeForm Me" from the load event, then empty fields display.
    c. The empty fields must display on the form, even if there are no records in the query.
    Thank you.

  9. #24
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    Hi
    I'm not sure I follow what you are saying.
    I don't see any reason why resizing code would affect what you see on your screen, whether or not the forms contain data.
    However, I'm happy to look into it

    Please can you email me (see link below) with a cut down version of your database removing anything not relevant to this issue & changing any confidential data.
    Then provide clear instructions on what I need to do to replicate it. A screenshot would help
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  10. #25
    Perfac's Avatar
    Perfac is offline Expert
    Windows 10 Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    Emailed. Thank you.

  11. #26
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,946
    Replied by email
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Access network design: FE configuration
    By Blings in forum Access
    Replies: 6
    Last Post: 07-14-2021, 03:34 PM
  2. Replies: 4
    Last Post: 03-16-2017, 04:04 AM
  3. Split configuration names
    By fuecheefang in forum Queries
    Replies: 6
    Last Post: 07-05-2016, 03:59 PM
  4. Replies: 2
    Last Post: 01-28-2014, 12:04 PM
  5. configuration failed
    By PURAN in forum Access
    Replies: 1
    Last Post: 05-15-2012, 03:39 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