Welcome to SPN

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

Sign Up Now!

Passing a number to retrive the name in a table

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

  1. tanhus

    tanhus
    Expand Collapse
    Guest

    Im trying to figure out how to retrieve the name from a team member table if
    i pass it the id number.


    ~TeamMember~
    TeamMemberID as number
    Name as text
     
  2. Loading...


  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Retrieve where?

    In a query, join the two tables together on TeamMemberID.

    In VBA, you can use DLookup("[Name]", "[TeamMember]", "[TeamMemberID] = " &
    IdNumber)

    Note that Name isn't a very good choice for a field name: it's a reserved
    word.

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


    "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    news:D7748CCC-FFDB-4D52-9373-08D0B136024A@microsoft.com...
    > Im trying to figure out how to retrieve the name from a team member table
    > if
    > i pass it the id number.
    >
    >
    > ~TeamMember~
    > TeamMemberID as number
    > Name as text
     
  4. tanhus

    tanhus
    Expand Collapse
    Guest

    thanks

    "Douglas J. Steele" wrote:

    > Retrieve where?
    >
    > In a query, join the two tables together on TeamMemberID.
    >
    > In VBA, you can use DLookup("[Name]", "[TeamMember]", "[TeamMemberID] = " &
    > IdNumber)
    >
    > Note that Name isn't a very good choice for a field name: it's a reserved
    > word.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "tanhus" <tanhus@discussions.microsoft.com> wrote in message
    > news:D7748CCC-FFDB-4D52-9373-08D0B136024A@microsoft.com...
    > > Im trying to figure out how to retrieve the name from a team member table
    > > if
    > > i pass it the id number.
    > >
    > >
    > > ~TeamMember~
    > > TeamMemberID as number
    > > Name as text

    >
    >
    >
     

Share This Page