OnScrollBarClick ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anything remotely like an Event procedure that allows me to run code
everytime the scroll bar is moved? The current record doesn't always change,
so I can't use OnCurrent. Any thoughts? Perhaps a workaround may be code to
always set the current record to the top visible row.
 
Unfortunately Access does nto expose any ScrollBar events. What is it you
are trying to accomplish?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Hi Stephen. I am trying to mimic the "freeze panes" feature in excel. I
have 2 subforms on a form. The subform on the left is a one column
continuous form whose dataset is the fieldnames for the data in subform2.
When I move around in subform2 (which is really long and wide), I need the
left side headings in subform 1 to move with subform2. After a LONG attempt
at using every variation of seltop, currentrecord, etc... I finally stumbled
onto you getsetscrollbar tool. It works like a charm as long as I have an
event to assign it too. however when I just click down the scroll bar, none
of the events set off.

I've had a good suggestion to elminate the scroll bars altogether and create
my own up/down buttons which could call your getset commands. However I
think your getset tools require the scrollbars to be visible.

any thoughts?
 
If you eliminate the ScrollBars then you could simply use the SelTop
property.

You might consider searching on this issue via GoogleGroups. I think
Albert(Access MVP) has posted an alternative solution to the issue.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top