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

Grab select on Right Mouse button

Discussion in 'Information Technology' started by Vic Spainhower, Nov 6, 2005.

  1. Vic Spainhower

    Vic Spainhower
    Expand Collapse
    Guest

    Hello,

    When the user selects a sort option using the right mouse button I want to
    grab this so that I can change the recordsource property for a subform. I
    have not been able to come up with a way to do this. Can someone help?

    Thanks,

    Vic
     
  2. Loading...

    Similar Threads Forum Date
    India Mumbai Land Grab Breaking News Dec 8, 2012
    USA US Has Snatch and Grab Plan for PAK Nukes Breaking News Aug 6, 2011
    Sir Mota Singh grabs 'Pride of Sikh Community' award Sikh Personalities May 3, 2010
    Sikh News Pak Army grabs Sikh Gurudwara land Breaking News Dec 18, 2009
    Sikh News Punjab rushes to grab Nano chance, offers 1,000 acres (Express India) Breaking News Aug 23, 2008

  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    My guess is that you can use the Form_Current Event since most of the time,
    the Current Record of the Form will change. The only exception occurs when
    the existing Current Record (just before ordering) is the first Record in
    the newly re-ordered Recordset of the Form.

    --
    HTH
    Van T. Dinh
    MVP (Access)




    "Vic Spainhower" <vicNoSpam@perfected.com> wrote in message
    news:%23g3Csfk4FHA.3636@TK2MSFTNGP09.phx.gbl...
    > Hello,
    >
    > When the user selects a sort option using the right mouse button I want to
    > grab this so that I can change the recordsource property for a subform. I
    > have not been able to come up with a way to do this. Can someone help?
    >
    > Thanks,
    >
    > Vic
    >
    >
    >
     
  4. Vic Spainhower

    Vic Spainhower
    Expand Collapse
    Guest

    Van,

    Thanks for the reply but I need to be able to see which column the user is
    sorting on. I don't see how I would be able to determine this in the
    Form_Current Event!

    Vic


    "Van T. Dinh" <VanThien.Dinh@discussions.microsoft.com> wrote in message
    news:uvfSMYl4FHA.1416@TK2MSFTNGP09.phx.gbl...
    > My guess is that you can use the Form_Current Event since most of the
    > time, the Current Record of the Form will change. The only exception
    > occurs when the existing Current Record (just before ordering) is the
    > first Record in the newly re-ordered Recordset of the Form.
    >
    > --
    > HTH
    > Van T. Dinh
    > MVP (Access)
    >
    >
    >
    >
    > "Vic Spainhower" <vicNoSpam@perfected.com> wrote in message
    > news:%23g3Csfk4FHA.3636@TK2MSFTNGP09.phx.gbl...
    >> Hello,
    >>
    >> When the user selects a sort option using the right mouse button I want
    >> to grab this so that I can change the recordsource property for a
    >> subform. I have not been able to come up with a way to do this. Can
    >> someone help?
    >>
    >> Thanks,
    >>
    >> Vic
    >>
    >>
    >>

    >
    >
     
  5. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    I am not sure but have you tried Screen.ActiveControl?

    --
    HTH
    Van T. Dinh
    MVP (Access)




    "Vic Spainhower" <vicNoSpam@perfected.com> wrote in message
    news:eFwlbnm4FHA.2552@TK2MSFTNGP10.phx.gbl...
    > Van,
    >
    > Thanks for the reply but I need to be able to see which column the user is
    > sorting on. I don't see how I would be able to determine this in the
    > Form_Current Event!
    >
    > Vic
    >
    >
     
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