Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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?

    >>
    >>
    >>
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page