Welcome to SPN

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

Sign Up Now!

Auto Selecting Sub Data Sheets

Discussion in 'Information Technology' started by aheath15, Jul 28, 2006.

  1. aheath15

    aheath15
    Expand Collapse
    Guest

    My Situation:

    I have a list of products, some of which contain sub-assemblies, which are
    then listed in sub-data sheets. For ordering purporses, a user can go down
    the table and select which products are needed (using a boolean field).
    Since some products contain sub-assemblies, I am trying to figure out the
    best way to have these sub-assembly components automatically selected to
    prevent the user from forgetting to order necessary products.

    I have been brainstorming ways to use queries/filters/etc, but have not been
    able to get this to work properly. Any suggestions? If so, it would be
    extremely helpful to explicitly let me know the 'terminology' of what's
    needed, as that has been my main problem thus far.

    Thanks!
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Is Autocomplete Evil? Some Women Take A Hard Look at Google ! Breaking News Nov 7, 2013
    Sikh News AutoZone sued for firing Everett Sikh Breaking News Sep 29, 2010
    India Singh: Centre Ready To Give Kashmir Autonomy Breaking News Aug 11, 2010
    India Paste tariff cards behind driver’s seat: Transport dept to automen Breaking News Jul 21, 2010
    Gursharan Kaur: India's First Lady's Autobiography Sikh Personalities Jun 1, 2010

  3. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    This is really, really kludgy, but here's how I accomplished that.
    You have to make sure the cursor is in the right cell, and then
    you issue the Shift + DOWN command using SendKeys.

    Me.WorkProgramID.SetFocus
    SendKeys "^+{DOWN}"

    Where you put this code will depend on what you're doing. I have
    it in the AfterInsert() of the record for the same reason you gave,
    because I want it as a reminder that there are sub records to enter.
    --

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "aheath15" <aheath15@discussions.microsoft.com> wrote in message
    news:8B48BBFC-E26F-4B9A-A198-395CA15FD6B4@microsoft.com...
    > My Situation:
    >
    > I have a list of products, some of which contain sub-assemblies, which are
    > then listed in sub-data sheets. For ordering purporses, a user can go down
    > the table and select which products are needed (using a boolean field).
    > Since some products contain sub-assemblies, I am trying to figure out the
    > best way to have these sub-assembly components automatically selected to
    > prevent the user from forgetting to order necessary products.
    >
    > I have been brainstorming ways to use queries/filters/etc, but have not been
    > able to get this to work properly. Any suggestions? If so, it would be
    > extremely helpful to explicitly let me know the 'terminology' of what's
    > needed, as that has been my main problem thus far.
    >
    > Thanks!
     

Share This Page