Simulate Excel's Freeze Panes functionality

  • Thread starter Thread starter Bill R via AccessMonster.com
  • Start date Start date
B

Bill R via AccessMonster.com

Are you aware of any method to simulate the "Freeze Panes" functionality of
Excel? Two continuous subforms should do the trick, but how do you get sfrm2
to synch up with sfrm1 (or vice versa)?
 
you want to set the master and child link in the properties of the
subform (sfrm2.ID = sfrm1.masterID or whatever your ID fields are) -
like make what you want to see .. then right click on the form
properties and you'll see something about Master and Child IDs.
hth
 
Thanks for your response.
Yes, that will ensure that the correlated data are in the 2 subforms, but the
problem arises from scrolling in one subform. How do you have the records in
the 2nd subform scroll in synchrony with the records in the 1st subform?
 
Bill

Is there a reason you don't just export the data to Excel and use the
spreadsheet's functionality?

Regards

Jeff Boyce
<Office/Access MVP>
 
Yes, the client wants to utilize Access due to the exponential growth of
scenarios to be plotted. If it proves to be impossibly difficult, or just
plain impossible, to mimic this aspect of Excel then I will be forced to
embed a spreadsheet on the page. I would like to avoid that if possible.

Bill
 
If it's a form in datasheet view then you can just use Freeze Columns from
the format menu, but if you can't use that then it will be a great deal more
complicated. The best thing that I can come up with would be a standalone
scrollbar with events attached to changes in that that hide/unhide labels
and change .left properties.

I did something similar in .Net recently and that was horrible. It would be
worse in Access.
 
OUCH!

Rob said:
If it's a form in datasheet view then you can just use Freeze Columns from
the format menu, but if you can't use that then it will be a great deal more
complicated. The best thing that I can come up with would be a standalone
scrollbar with events attached to changes in that that hide/unhide labels
and change .left properties.

I did something similar in .Net recently and that was horrible. It would be
worse in Access.
Click to expand...
 
Back
Top