Marshall Brooks
Member
- Local time
- Today, 05:53
- Joined
- Feb 28, 2023
- Messages
- 720
This one has me baffled. I created a new status bar/navigation pane in this thread: https://www.access-programmers.co.u...-add-new-record-button-only-how.329982/page-3
We've been using it for some time. I was using this code in the Form Open procedure:
FooterBanner is just a rectangle which is the height of the navigation buttons. The navigation buttons are 3.25 inches wide, so this code makes the navigation buttons centered and the footerbanner go to the start of the navigation buttons and then the buttons go to the right.
This code also seems to work and is somewhat simpler:
Most of our team uses 1920x or less screen resolution and the database is maximized when opening.
Recently, we added a new user who is using 3840x1600 resolution and she was getting the subject error, so I commented out the code above and the database opened without issues. I added a message box and the database shows my form width as 25650 for both .width and .insideWidth. For her, it shows width of 25650 and 24840, which doesn't make sense to me. (Also, she is running the database on a laptop at 3840x1600 and remoting into it from another laptop at the same resolution - which I don't think should matter.)
I tried stepping through the code, and I got the above error on the second line, which doesn't make much sense to me, b/c that line should be setting the width of the footerbanner to less than half of the form width.
Then I tried changing line two to the code above and I got an error "Overflow" - and I got that same error if I changed that line to Me.FooterBanner.Width = Me.InsideWidth - 100.
Does anyone see some error that I am missing?
We've been using it for some time. I was using this code in the Form Open procedure:
Code:
Me.FooterBanner.left = 0
Me.FooterBanner.Width = (Me.InsideWidth / 2) - (1.625 * 1440)
Me.zz_frmNavButtons.left = (Me.InsideWidth / 2) - (1.625 * 1440)
Me.zz_frmNavButtons.Width = (Me.InsideWidth / 2) + (1.625 * 1440)
FooterBanner is just a rectangle which is the height of the navigation buttons. The navigation buttons are 3.25 inches wide, so this code makes the navigation buttons centered and the footerbanner go to the start of the navigation buttons and then the buttons go to the right.
This code also seems to work and is somewhat simpler:
Code:
Me.FooterBanner.left = 0
Me.FooterBanner.Width = Me.InsideWidth
Me.zz_frmNavButtons.left = (Me.InsideWidth / 2) - (1.625 * 1440)
Most of our team uses 1920x or less screen resolution and the database is maximized when opening.
Recently, we added a new user who is using 3840x1600 resolution and she was getting the subject error, so I commented out the code above and the database opened without issues. I added a message box and the database shows my form width as 25650 for both .width and .insideWidth. For her, it shows width of 25650 and 24840, which doesn't make sense to me. (Also, she is running the database on a laptop at 3840x1600 and remoting into it from another laptop at the same resolution - which I don't think should matter.)
I tried stepping through the code, and I got the above error on the second line, which doesn't make much sense to me, b/c that line should be setting the width of the footerbanner to less than half of the form width.
Then I tried changing line two to the code above and I got an error "Overflow" - and I got that same error if I changed that line to Me.FooterBanner.Width = Me.InsideWidth - 100.
Does anyone see some error that I am missing?