Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Mouse Move Event

Discussion in 'Information Technology' started by PeterM, Nov 4, 2005.

Tags:
  1. PeterM

    PeterM
    Expand Collapse
    Guest

    I have a form displaying records in a continuous format. There are 4 fields
    on the continuous form. I have a mouse move event for field1 on the form
    that displays the contents of field 2 in another field on the same form.

    The problem is that when I put the cursor over the 2nd or 3rd entry on the
    continuous form, it always displays the 1st entries information. Is there a
    way to get at the 2nd or 3rd rows information?
     
  2. Loading...


  3. Stephen Lebans

    Stephen Lebans
    Expand Collapse
    Guest

    See:
    http://www.lebans.com/conformscurcontrol.htm
    ContinuousFormsCurrentRow.zip is a class that allows you to programmatically
    access the contents of a bound control, as the user moves their Mouse, but
    the control does not have the focus. For Forms in Continuous View.
    --

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


    "PeterM" <PeterM@discussions.microsoft.com> wrote in message
    news:60BD01DC-F670-45DF-9922-0BFFB511F4EC@microsoft.com...
    >I have a form displaying records in a continuous format. There are 4
    >fields
    > on the continuous form. I have a mouse move event for field1 on the form
    > that displays the contents of field 2 in another field on the same form.
    >
    > The problem is that when I put the cursor over the 2nd or 3rd entry on the
    > continuous form, it always displays the 1st entries information. Is there
    > a
    > way to get at the 2nd or 3rd rows information?
     
  4. PeterM

    PeterM
    Expand Collapse
    Guest

    thank you for your reply...

    however, when the mouse moves over row 1, it dispays the contents of row 2,
    when the mouse moves over row 2, it displays the contents of row 1 and when
    the mouse moves over row 3, it displays the contents of row 2 which means it
    never displays the contents of row 3.

    I had to convert it from Acc97 to Acc2002 for my project, could that be
    causing the problem?

    "Stephen Lebans" wrote:

    > See:
    > http://www.lebans.com/conformscurcontrol.htm
    > ContinuousFormsCurrentRow.zip is a class that allows you to programmatically
    > access the contents of a bound control, as the user moves their Mouse, but
    > the control does not have the focus. For Forms in Continuous View.
    > --
    >
    > HTH
    > Stephen Lebans
    > http://www.lebans.com
    > Access Code, Tips and Tricks
    > Please respond only to the newsgroups so everyone can benefit.
    >
    >
    > "PeterM" <PeterM@discussions.microsoft.com> wrote in message
    > news:60BD01DC-F670-45DF-9922-0BFFB511F4EC@microsoft.com...
    > >I have a form displaying records in a continuous format. There are 4
    > >fields
    > > on the continuous form. I have a mouse move event for field1 on the form
    > > that displays the contents of field 2 in another field on the same form.
    > >
    > > The problem is that when I put the cursor over the 2nd or 3rd entry on the
    > > continuous form, it always displays the 1st entries information. Is there
    > > a
    > > way to get at the 2nd or 3rd rows information?

    >
    >
    >
     
  5. PeterM

    PeterM
    Expand Collapse
    Guest

    additionally, when I have the form display the row number:

    row 1 = -1
    row 2 = 0
    row 3 = 1
    row 4 = 2

    etc.

    "Stephen Lebans" wrote:

    > See:
    > http://www.lebans.com/conformscurcontrol.htm
    > ContinuousFormsCurrentRow.zip is a class that allows you to programmatically
    > access the contents of a bound control, as the user moves their Mouse, but
    > the control does not have the focus. For Forms in Continuous View.
    > --
    >
    > HTH
    > Stephen Lebans
    > http://www.lebans.com
    > Access Code, Tips and Tricks
    > Please respond only to the newsgroups so everyone can benefit.
    >
    >
    > "PeterM" <PeterM@discussions.microsoft.com> wrote in message
    > news:60BD01DC-F670-45DF-9922-0BFFB511F4EC@microsoft.com...
    > >I have a form displaying records in a continuous format. There are 4
    > >fields
    > > on the continuous form. I have a mouse move event for field1 on the form
    > > that displays the contents of field 2 in another field on the same form.
    > >
    > > The problem is that when I put the cursor over the 2nd or 3rd entry on the
    > > continuous form, it always displays the 1st entries information. Is there
    > > a
    > > way to get at the 2nd or 3rd rows information?

    >
    >
    >
     
  6. PeterM

    PeterM
    Expand Collapse
    Guest

    sorry...once I looked at the code, I discovered that it will only work if
    scroll bars are turned on for the form...I enabled vertical scroll bars and
    it worked fine...thanks again for your help..................

    "Stephen Lebans" wrote:

    > See:
    > http://www.lebans.com/conformscurcontrol.htm
    > ContinuousFormsCurrentRow.zip is a class that allows you to programmatically
    > access the contents of a bound control, as the user moves their Mouse, but
    > the control does not have the focus. For Forms in Continuous View.
    > --
    >
    > HTH
    > Stephen Lebans
    > http://www.lebans.com
    > Access Code, Tips and Tricks
    > Please respond only to the newsgroups so everyone can benefit.
    >
    >
    > "PeterM" <PeterM@discussions.microsoft.com> wrote in message
    > news:60BD01DC-F670-45DF-9922-0BFFB511F4EC@microsoft.com...
    > >I have a form displaying records in a continuous format. There are 4
    > >fields
    > > on the continuous form. I have a mouse move event for field1 on the form
    > > that displays the contents of field 2 in another field on the same form.
    > >
    > > The problem is that when I put the cursor over the 2nd or 3rd entry on the
    > > continuous form, it always displays the 1st entries information. Is there
    > > a
    > > way to get at the 2nd or 3rd rows information?

    >
    >
    >
     
  7. Stephen Lebans

    Stephen Lebans
    Expand Collapse
    Guest

    Glad you figured it out yourself. I was getting ready to answer you.<grin>

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


    "PeterM" <PeterM@discussions.microsoft.com> wrote in message
    news:C23FF67D-4624-48C8-A4D2-183B3F8CE3D1@microsoft.com...
    > sorry...once I looked at the code, I discovered that it will only work if
    > scroll bars are turned on for the form...I enabled vertical scroll bars
    > and
    > it worked fine...thanks again for your help..................
    >
    > "Stephen Lebans" wrote:
    >
    >> See:
    >> http://www.lebans.com/conformscurcontrol.htm
    >> ContinuousFormsCurrentRow.zip is a class that allows you to
    >> programmatically
    >> access the contents of a bound control, as the user moves their Mouse,
    >> but
    >> the control does not have the focus. For Forms in Continuous View.
    >> --
    >>
    >> HTH
    >> Stephen Lebans
    >> http://www.lebans.com
    >> Access Code, Tips and Tricks
    >> Please respond only to the newsgroups so everyone can benefit.
    >>
    >>
    >> "PeterM" <PeterM@discussions.microsoft.com> wrote in message
    >> news:60BD01DC-F670-45DF-9922-0BFFB511F4EC@microsoft.com...
    >> >I have a form displaying records in a continuous format. There are 4
    >> >fields
    >> > on the continuous form. I have a mouse move event for field1 on the
    >> > form
    >> > that displays the contents of field 2 in another field on the same
    >> > form.
    >> >
    >> > The problem is that when I put the cursor over the 2nd or 3rd entry on
    >> > the
    >> > continuous form, it always displays the 1st entries information. Is
    >> > there
    >> > a
    >> > way to get at the 2nd or 3rd rows information?

    >>
    >>
    >>
     

Share This Page