Welcome to SPN

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

Sign Up Now!

Dlookup for 2 fields

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

Tags:
  1. Tom

    Tom
    Expand Collapse
    Guest

    Hi all,

    This post is related to my previous post from 5\22\06 "A Challenge".

    If I will create a table with all the combinations, how can I create a
    Dlookup function that will find the right one and will populate the grade
    field.

    Is Dlookup is the right function?

    I will be grateful for any input about this.

    Thanks,
    Tom
     
  2. Loading...

    Similar Threads Forum Date
    US Defense Department Hiring Resident Aliens in Medical and Language Fields Business, Lifestyle & Leisure Dec 6, 2008
    Sikh News Women more vulnerable to cancer in Punjab's cotton fields (New Kerala) Breaking News Apr 1, 2008
    Sikh News Women more vulnerable to cancer in Punjab's cotton fields (Calcutta News) Breaking News Apr 1, 2008
    Sikh News Punjab's killing fields (The Times of India) Breaking News Feb 24, 2008
    Sikh News MQM fields 218 candidates in Punjab (The Pakistan Link) Breaking News Feb 1, 2008

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Don't expect people to go searching for previous posts. Give sufficient
    information so that the post stands alone, or else put this question in the
    original thread.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Tom" <partner1973@yahoo.com> wrote in message
    news:egBMD2tfGHA.4864@TK2MSFTNGP05.phx.gbl...
    > Hi all,
    >
    > This post is related to my previous post from 5\22\06 "A Challenge".
    >
    > If I will create a table with all the combinations, how can I create a
    > Dlookup function that will find the right one and will populate the grade
    > field.
    >
    > Is Dlookup is the right function?
    >
    > I will be grateful for any input about this.
    >
    > Thanks,
    > Tom
    >
    >
     
  4. Tom

    Tom
    Expand Collapse
    Guest

    Sorry about that
    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:OLXsBMyfGHA.4892@TK2MSFTNGP02.phx.gbl...
    > Don't expect people to go searching for previous posts. Give sufficient
    > information so that the post stands alone, or else put this question in
    > the
    > original thread.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Tom" <partner1973@yahoo.com> wrote in message
    > news:egBMD2tfGHA.4864@TK2MSFTNGP05.phx.gbl...
    >> Hi all,
    >>
    >> This post is related to my previous post from 5\22\06 "A Challenge".
    >>
    >> If I will create a table with all the combinations, how can I create a
    >> Dlookup function that will find the right one and will populate the grade
    >> field.
    >>
    >> Is Dlookup is the right function?
    >>
    >> I will be grateful for any input about this.
    >>
    >> Thanks,
    >> Tom
    >>
    >>

    >
    >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    However,
    You can use a Recordset to retrieve the combination

    Pieter



    "Tom" <partner1973@yahoo.com> wrote in message
    news:eKs5g7zfGHA.1520@TK2MSFTNGP03.phx.gbl...
    > Sorry about that
    > "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > news:OLXsBMyfGHA.4892@TK2MSFTNGP02.phx.gbl...
    >> Don't expect people to go searching for previous posts. Give sufficient
    >> information so that the post stands alone, or else put this question in
    >> the
    >> original thread.
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>
    >>
    >> "Tom" <partner1973@yahoo.com> wrote in message
    >> news:egBMD2tfGHA.4864@TK2MSFTNGP05.phx.gbl...
    >>> Hi all,
    >>>
    >>> This post is related to my previous post from 5\22\06 "A Challenge".
    >>>
    >>> If I will create a table with all the combinations, how can I create a
    >>> Dlookup function that will find the right one and will populate the
    >>> grade
    >>> field.
    >>>
    >>> Is Dlookup is the right function?
    >>>
    >>> I will be grateful for any input about this.
    >>>
    >>> Thanks,
    >>> Tom
    >>>
    >>>

    >>
    >>

    >
    >
     
  6. Ron2006

    Ron2006
    Expand Collapse
    Guest

    Since the grade is already associated with the two items you mentioned,
    it could simply be a part of that second query that you are doing for
    the second combo box.

    Then all you have to do is add code to the afterupdate event of the
    combobox to do the following

    me.gradefieldnameonform = me.combobox2.column(2)

    The columns are numbered relative to 0 so the third field in the query
    is referenced as column(2).
     
  7. Tom

    Tom
    Expand Collapse
    Guest

    Thank you all.
    "Ron2006" <ronnemec@hotmail.com> wrote in message
    news:1148494640.060308.184310@g10g2000cwb.googlegroups.com...
    > Since the grade is already associated with the two items you mentioned,
    > it could simply be a part of that second query that you are doing for
    > the second combo box.
    >
    > Then all you have to do is add code to the afterupdate event of the
    > combobox to do the following
    >
    > me.gradefieldnameonform = me.combobox2.column(2)
    >
    > The columns are numbered relative to 0 so the third field in the query
    > is referenced as column(2).
    >
     

Share This Page