Anybody know a shitload about Access?

Discussion in 'OT Technology' started by jrmcm, Mar 13, 2003.

  1. jrmcm

    jrmcm Actriz Porno

    Joined:
    Oct 9, 2001
    Messages:
    57,397
    Likes Received:
    333
    Location:
    Plano, TX
    Bueller... Bueller?
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Unfortunately yes.
     
  3. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    i know quite a bit, but that 5Gen_Prelude is the shizzle :big grin:
     
  4. jrmcm

    jrmcm Actriz Porno

    Joined:
    Oct 9, 2001
    Messages:
    57,397
    Likes Received:
    333
    Location:
    Plano, TX
    :cool: I have a question, then...

    I've got a table (of employees) that has last name and first name in two different colums. I've got a web form in which I want to be able to select an employee name from a drop down list that pulls from that employee table, but I want it to display both last name and first name. In the typical access form, that's not a problem because I can do that with a combo box, but you can't put combo boxes on web forms. So, any suggestions? I would assume that I could create a query or something of that nature to combine the values from the first name and last name colums into one field and then have the web form drop down list pull from that query. But, I'm not sure that would work, and even if it would, I wouldn't know how to do it (I know jack shit about Access). Any help is greatly appreciated. :)
     
  5. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    well, the query is the easy part. Are you talking about the webforms inside Access? I'm not familiar with those. But the query would look something like the following:

    Select FirstName & " " & LastName From Employees
     
  6. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    You mean you can't put multi-column combo boxes in a web form right?
     
  7. jrmcm

    jrmcm Actriz Porno

    Joined:
    Oct 9, 2001
    Messages:
    57,397
    Likes Received:
    333
    Location:
    Plano, TX
    correct
     
  8. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Then SLED's answer is fine. I mean normally you would index off of the EmployeeID (ie 2 columns, 1st is hidden with a 0" width, and the second as the Employee Name). That way the data returned is a number not a stored string which in most cases is better. Otherwise you end up having to reverse the query out (ie Which Employee ID has a first name of Joe and a last name of Smith - hoping like hell no one has spaces in their name).
     

Share This Page