M
ManuPR
Is there a way to determine the current row that is under the mouse pointer
on a continuous form without having to select the record frst?
I'm working on creating an application to book appointments. I created a
calendar form that displays one week at a time. The form is divided in
columns that represent the days of the week and each row is a different time
of the day, kind of like the week view in Outlook. The space is limited so I
can't display as much info about the appointment as I would like. I thought
about displaying custom tool tips with more info about the appointment when
the user moves the mouse over the calendar. The problem is that I used a
continuous form to display one record for each hour of the day so when I move
the mouse over a row that is not the selected one the tooltip displays the
information of the row that is selected. I tried to use a solution from
Stephen Lebans called ContinuousFormsCurrentRow
(http://www.lebans.com/conformscurcontrol.htm) but it doesn't seem to work
well on Access 2007 when you scroll down through records on the form. After
you scroll down it starts counting the rows from 1 again from the row
displayed on top. This solution calls an API function to determine the
position of the vertical scroll bar and calculate the current row under the
mouse pointer, but the API function always return the same value regardless
of the scroll bar position.
I would appreciate any comments on this. Thanks.
on a continuous form without having to select the record frst?
I'm working on creating an application to book appointments. I created a
calendar form that displays one week at a time. The form is divided in
columns that represent the days of the week and each row is a different time
of the day, kind of like the week view in Outlook. The space is limited so I
can't display as much info about the appointment as I would like. I thought
about displaying custom tool tips with more info about the appointment when
the user moves the mouse over the calendar. The problem is that I used a
continuous form to display one record for each hour of the day so when I move
the mouse over a row that is not the selected one the tooltip displays the
information of the row that is selected. I tried to use a solution from
Stephen Lebans called ContinuousFormsCurrentRow
(http://www.lebans.com/conformscurcontrol.htm) but it doesn't seem to work
well on Access 2007 when you scroll down through records on the form. After
you scroll down it starts counting the rows from 1 again from the row
displayed on top. This solution calls an API function to determine the
position of the vertical scroll bar and calculate the current row under the
mouse pointer, but the API function always return the same value regardless
of the scroll bar position.
I would appreciate any comments on this. Thanks.