vmccune
asked on
synchronize horizontal scroll bars
I want to synchronize 3 horizontal scrollbars on a main form. Each sub form is for example Qtr 1, Qtr 2, etc and I want them all to scroll left and right together. No I cannot combine them into one form and I do not want to move them to Excel.
Thanks.
Thanks.
What do you mean by "sync"? Do you want them at the same "position" (like 25% of the width), or something else?
You can sync several subform - highlighting the same ID so it always will be within the displayed records of the subform controls, but you can't control the absolute vertical position. It is not that difficult:
Synchronizing Multiple Subforms in Access
The horisontal position you should be able to control by setting focus on the column in the other subform(s) that matches the subform control actively used by the user. Again, that will only bring it into the viewable "windows" of columns, not set the absolute position.
/gustav
Synchronizing Multiple Subforms in Access
The horisontal position you should be able to control by setting focus on the column in the other subform(s) that matches the subform control actively used by the user. Again, that will only bring it into the viewable "windows" of columns, not set the absolute position.
/gustav
ASKER
The sub forms contain fields and records that go 3 times wider and twice as tall as the form can display. If I scroll 1/3 across the top form, I want it to scroll that far across the other ones. same for selecting records vertically.
That is not possible as scrolling is not a trackable event in VBA.
/gustav
/gustav
Rather than tracking the scroll bar itself, what about providing buttons for a user to scroll around with?
Check out this old comment here:
https://www.experts-exchange.com/questions/26374787/Getting-Setting-Form-Scroll-Bar-positions.html?anchorAnswerId=33354326#a33354326
Using a page control, you can set forms to the exact same place by using the right and down arguments.
I thought too someone had read the position of a scroll bar at one point....let me dig around.
Jim.
Check out this old comment here:
https://www.experts-exchange.com/questions/26374787/Getting-Setting-Form-Scroll-Bar-positions.html?anchorAnswerId=33354326#a33354326
Using a page control, you can set forms to the exact same place by using the right and down arguments.
I thought too someone had read the position of a scroll bar at one point....let me dig around.
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
vmccune,
Most UI developers will frown on forms that need to be scrolled "Horizontally"
Can your forms be widened to eliminate the need for scrolling?
As the others have stated, ...you can get the "record" (vertical) position, ...but it is a lot harder to figure out the "Horizontal" position.
What is the actual structure (Fields) of the data in the subforms?
Most UI developers will frown on forms that need to be scrolled "Horizontally"
Can your forms be widened to eliminate the need for scrolling?
As the others have stated, ...you can get the "record" (vertical) position, ...but it is a lot harder to figure out the "Horizontal" position.
What is the actual structure (Fields) of the data in the subforms?
ASKER
It took some doing but this worked perfeclty