Outlook Contact Form Full name
in [Form]
|
From: love on 20 Mar 2010 17:53 "Billiam" <Billiam(a)discussions.microsoft.com> wrote in message news:7882BE6F-B00C-43B2-8B59-DB696C18314A(a)microsoft.com... >I am trying to create a form like the outlook 2007 Contact Manager Form. > The Outlook Contact form itself...should it be bound or unbound and why. I > started by having it unbound and using the Full Name command button to > open > the Full name details form which is bound to the People table....but how > do I > get the concatenated full name with salutation and suffix to appear in the > text box beside the fullname command button, and autofill the business > card > with the concatenated name? > I assumed I could simply base the textbox on a concatenation of the info > that was entered in the bound pop up Full name details form, but because I > store the ID's of Salutation and suffix, I end up with numbers at the > beginning and end. > > My People Table: > PeopleID PK autonumber > FName text > MName text > LName text > PrefFName text > SalutID > SuffixID > > Any help on how to do this would be a great learning experience, and would > help me setup my contact form. > > Thanks so much for any help! > Billiam
From: love on 23 Mar 2010 17:12 "Billiam" <Billiam(a)discussions.microsoft.com> wrote in message news:7882BE6F-B00C-43B2-8B59-DB696C18314A(a)microsoft.com... >I am trying to create a form like the outlook 2007 Contact Manager Form. > The Outlook Contact form itself...should it be bound or unbound and why. I > started by having it unbound and using the Full Name command button to > open > the Full name details form which is bound to the People table....but how > do I > get the concatenated full name with salutation and suffix to appear in the > text box beside the fullname command button, and autofill the business > card > with the concatenated name? > I assumed I could simply base the textbox on a concatenation of the info > that was entered in the bound pop up Full name details form, but because I > store the ID's of Salutation and suffix, I end up with numbers at the > beginning and end. > > My People Table: > PeopleID PK autonumber > FName text > MName text > LName text > PrefFName text > SalutID > SuffixID > > Any help on how to do this would be a great learning experience, and would > help me setup my contact form. > > Thanks so much for any help! > Billiam
|
Pages: 1 Prev: How to update control Next: Why wont this control show whole numbers? |