Welcome to SPN

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

Sign Up Now!

Simple question combining first initial and last name

Discussion in 'Information Technology' started by emanuel.levy@gmail.com, Nov 3, 2005.

  1. emanuel.levy@gmail.com

    emanuel.levy@gmail.com
    Expand Collapse
    Guest

    I have an Employee Table composed of 3 items
    A Primay Key which is Auto Number
    First Initital
    Last name

    I'm trying to use them in a new table where when you click on Employee
    it shows the list of employees. On the initial screen it shows the
    First Initial and Last name but once you go to the next field it shows
    only the First Initial. How do I make it keep both displayed?
     
  2. Loading...

    Similar Threads Forum Date
    Grammer / Vyakarn Learn Simple & Easiest Gurbani Vyakaran/grammer From Prof. Maninderpal Singh Language, Arts & Culture Mar 9, 2015
    General Babaji Ranjit Singh Dhandrian Wale, Simple living high Thinking Hard Talk Sep 27, 2013
    Sikh Weddings Simple? No, they Are Indulged In Brahmanwad Questions and Answers Sep 15, 2012
    The One-Minute Mystic: Simple Things You Can Do to Stay Connected Spiritual Articles May 23, 2011
    Being a Simple Sikh (blog of a Prithihardkaur Sikh) Spiritual Articles Sep 13, 2010

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Not sure I understand your question since you say your trying to use them
    "in a new table" then you say "on the initial screen". Are you doing this
    in a table or a form?

    In any case, the whole point of a relational database is to store the data
    in only one place, and to point to it from other places. The short answer
    is that you can DISPLAY the name in any format you wish using unbound text
    fields in forms, queries, and reports, but you don't store it a second time.

    To show what you want in a form, add an unbound field and put the following
    in it...

    =[FirstInitial] & ". " & [LastName]


    --
    Rick B



    <emanuel.levy@gmail.com> wrote in message
    news:1130944299.216795.80490@o13g2000cwo.googlegroups.com...
    >I have an Employee Table composed of 3 items
    > A Primay Key which is Auto Number
    > First Initital
    > Last name
    >
    > I'm trying to use them in a new table where when you click on Employee
    > it shows the list of employees. On the initial screen it shows the
    > First Initial and Last name but once you go to the next field it shows
    > only the First Initial. How do I make it keep both displayed?
    >
     
  4. emanuel.levy@gmail.com

    emanuel.levy@gmail.com
    Expand Collapse
    Guest

    Ok. On the Data tab it shows

    Row Source Type Table/Query
    Row Source SELECT tblsafety_Employees.tblSaftey_EmployeesID,
    tblsafety_Employees.[First Initial], tblsafety_Employees.[Last Name]
    FROM tblsafety_Employees;
    Bound Column 1
    Limit to List Yes
    Auto Expand Yes

    I'm doing this in a Form so someone else can assign employees to tasks.
     
  5. Rick B

    Rick B
    Expand Collapse
    Guest

    Ok, so that selects the appropriate employee number and stores it in your
    table, right?

    Now, if you want to display the employee name, add an Unbound Text Box to
    the right of that field and set it to show the employee name as I indicated
    in my first post.


    --
    Rick B



    <emanuel.levy@gmail.com> wrote in message
    news:1130946157.438905.224150@g14g2000cwa.googlegroups.com...
    > Ok. On the Data tab it shows
    >
    > Row Source Type Table/Query
    > Row Source SELECT tblsafety_Employees.tblSaftey_EmployeesID,
    > tblsafety_Employees.[First Initial], tblsafety_Employees.[Last Name]
    > FROM tblsafety_Employees;
    > Bound Column 1
    > Limit to List Yes
    > Auto Expand Yes
    >
    > I'm doing this in a Form so someone else can assign employees to tasks.
    >
     
  6. emanuel.levy@gmail.com

    emanuel.levy@gmail.com
    Expand Collapse
    Guest

    Ok I semi understand. I'm using the following code now for Row Source

    SELECT tblsafety_Employees.tblSaftey_EmployeesID,
    tblsafety_Employees.[First Initial] & "." & tblsafety_Employees.[Last
    Name], tblsafety_Employees.[Last Name] FROM tblsafety_Employees;

    When I look at the records in the Form it shows the First Initial and
    last name which is perfect. When I manually look at the employer table
    it shows the first initial which is fine

    Howver when I am using the form to enter employer info I have having a
    problem. When I click on the drop down to get the list instead of
    showing something like

    K | Clarkson
    M | Jackson
    P | Gabriel
    B | Joel
    E | John


    It shows

    K.Clarkson | Clarksson
    M.Jackson | Jackson
    P.Gabriel | Gabriel
    B.Joel | Joel
    E.John | John

    What did I do wrong to cause that?
     
  7. Rick B

    Rick B
    Expand Collapse
    Guest

    This should work exactly like the "Salesperson" field in the Northwinds
    ORDERS form and table. Take a look at how it works and see if that helps.
    I'm not following your post very well. I must be a bit fuzzy today.

    Maybe someone else can jump in and see what I'm missing.


    --
    Rick B



    <emanuel.levy@gmail.com> wrote in message
    news:1130951859.721541.132710@f14g2000cwb.googlegroups.com...
    > Ok I semi understand. I'm using the following code now for Row Source
    >
    > SELECT tblsafety_Employees.tblSaftey_EmployeesID,
    > tblsafety_Employees.[First Initial] & "." & tblsafety_Employees.[Last
    > Name], tblsafety_Employees.[Last Name] FROM tblsafety_Employees;
    >
    > When I look at the records in the Form it shows the First Initial and
    > last name which is perfect. When I manually look at the employer table
    > it shows the first initial which is fine
    >
    > Howver when I am using the form to enter employer info I have having a
    > problem. When I click on the drop down to get the list instead of
    > showing something like
    >
    > K | Clarkson
    > M | Jackson
    > P | Gabriel
    > B | Joel
    > E | John
    >
    >
    > It shows
    >
    > K.Clarkson | Clarksson
    > M.Jackson | Jackson
    > P.Gabriel | Gabriel
    > B.Joel | Joel
    > E.John | John
    >
    > What did I do wrong to cause that?
    >
     
  8. emanuel.levy@gmail.com

    emanuel.levy@gmail.com
    Expand Collapse
    Guest

    Would this Northwinds Orders form and table be on the Microsoft site or
    on the Office cd? The admin people here did not install any extra
    featurs for access and I have no sample databses on the system
    Rick B wrote:
    > This should work exactly like the "Salesperson" field in the Northwinds
    > ORDERS form and table. Take a look at how it works and see if that helps.
    > I'm not following your post very well. I must be a bit fuzzy today.
    >
    > Maybe someone else can jump in and see what I'm missing.
    >
    >
    > --
    > Rick B
    >
     
  9. Rick B

    Rick B
    Expand Collapse
    Guest

    Ah sorry. It ships with the application. It is on the CD. You might be
    able to get it on the Microsoft website. I've never looked.


    --
    Rick B



    <emanuel.levy@gmail.com> wrote in message
    news:1130954365.147810.249030@o13g2000cwo.googlegroups.com...
    > Would this Northwinds Orders form and table be on the Microsoft site or
    > on the Office cd? The admin people here did not install any extra
    > featurs for access and I have no sample databses on the system
    > Rick B wrote:
    >> This should work exactly like the "Salesperson" field in the Northwinds
    >> ORDERS form and table. Take a look at how it works and see if that
    >> helps.
    >> I'm not following your post very well. I must be a bit fuzzy today.
    >>
    >> Maybe someone else can jump in and see what I'm missing.
    >>
    >>
    >> --
    >> Rick B
    >>

    >
     
  10. emanuel.levy@gmail.com

    emanuel.levy@gmail.com
    Expand Collapse
    Guest

    I didn't find it on the Microsoft site. Out system tech won't install
    the sample file. Is there any chance you can either e-mail me or put
    the file on a site I can get it from.
     
  11. Fred Boer

    Fred Boer
    Expand Collapse
    Guest

    Hello:

    Go to www.microsoft.com.
    Enter "Northwind traders" in the search box on top right.
    The sixth link listed in the results will take you to a page where you can
    download the file for Access97.
    The seventh link listed in the results will take you to a page where you can
    download the file for Access 2000 (this will work in Access XP and 2003).
    or...

    The exact link is (watch for word wrap):

    http://www.microsoft.com/downloads/...c8-b91a-4603-8467-20215e441528&displaylang=en

    http://www.microsoft.com/downloads/...72-8dbe-422b-8676-c632d66c529c&displaylang=en


    HTH
    Fred Boer

    <emanuel.levy@gmail.com> wrote in message
    news:1130956841.866013.124670@o13g2000cwo.googlegroups.com...
    >I didn't find it on the Microsoft site. Out system tech won't install
    > the sample file. Is there any chance you can either e-mail me or put
    > the file on a site I can get it from.
    >
     
  12. emanuel.levy@gmail.com

    emanuel.levy@gmail.com
    Expand Collapse
    Guest

    Thanks that helped immensely
     
  13. emanuel.levy@gmail.com

    emanuel.levy@gmail.com
    Expand Collapse
    Guest

    I just noticed it's displying the full name in the field but on the
    drop down it is limiting the display to 5 letters for the last name how
    do I fix that?
     

Share This Page