Results 1 to 6 of 6
  1. #1
    shani908 is offline Novice
    Windows 11 Access 2019
    Join Date
    Feb 2023
    Posts
    24

    Access Contact Template, Full name

    Hello



    I am using one of the free templates provided my microsoft. This template is "Contacts" template. Can anyone please explain where is field "Contact Name" define ?
    It doesnt exist in any of the default table.

    Also is there a good guide how to to modify the free templates ?.

    Thanks
    Attached Thumbnails Attached Thumbnails contact_default_template.png  

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Have a look at the form's record source, it is probably in there as a concatenation of the first and last names.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    It's in the ContactsExtended query, which is the recordsource for the form.

  4. #4
    shani908 is offline Novice
    Windows 11 Access 2019
    Join Date
    Feb 2023
    Posts
    24
    Quote Originally Posted by davegri View Post
    It's in the ContactsExtended query, which is the recordsource for the form.
    Thanks .. just noted .
    Is there any place to understand how this is working ?

    thanks

    File As: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name]))

  5. #5
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    File As: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name]))


    It's an attempt to adjust for the user omitting the First or last name by substituting the company name. Proper data entry will eliminate the need for such twisted logic.

    For what it's worth, I have made a cause for myself to modify most of the poorly designed Microsoft supplied templates to modern standards of practice.
    Here's what I have for the Contact Management template:

    ModContactManager.zip

    In addition to many other changes the table design improvements are shown below;
    Plainly showing primary and foreign keys
    Removing spaces and special characters from data name fields in tables
    Removing attachments
    Removing a table lookup
    Modifying forms, reports, etc to accommodate revised data names.

    Click image for larger version. 

Name:	ContactORIG.png 
Views:	15 
Size:	14.5 KB 
ID:	49625 Click image for larger version. 

Name:	contactMOD_.png 
Views:	16 
Size:	13.0 KB 
ID:	49626
    Last edited by davegri; 02-03-2023 at 12:46 PM.

  6. #6
    shani908 is offline Novice
    Windows 11 Access 2019
    Join Date
    Feb 2023
    Posts
    24
    Thanks. Noted.


    Quote Originally Posted by davegri View Post


    It's an attempt to adjust for the user omitting the First or last name by substituting the company name. Proper data entry will eliminate the need for such twisted logic.

    For what it's worth, I have made a cause for myself to modify most of the poorly designed Microsoft supplied templates to modern standards of practice.
    Here's what I have for the Contact Management template:

    ModContactManager.zip

    In addition to many other changes the table design improvements are shown below;
    Plainly showing primary and foreign keys
    Removing spaces and special characters from data name fields in tables
    Removing attachments
    Removing a table lookup

    Click image for larger version. 

Name:	ContactORIG.png 
Views:	15 
Size:	14.5 KB 
ID:	49625 Click image for larger version. 

Name:	contactMOD_.png 
Views:	16 
Size:	13.0 KB 
ID:	49626

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Exporting my Contact Report from Access to Word
    By clrockwell15 in forum Import/Export Data
    Replies: 2
    Last Post: 06-29-2021, 07:46 PM
  2. Issue Tracking template contact email addresses
    By Poohbear0471 in forum Access
    Replies: 4
    Last Post: 11-09-2018, 10:46 AM
  3. Replies: 12
    Last Post: 04-16-2015, 04:44 PM
  4. Replies: 4
    Last Post: 01-30-2011, 12:36 PM
  5. Access Contact Database
    By gpeterson82 in forum Access
    Replies: 0
    Last Post: 10-30-2008, 09:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums