PC Review


Reply
Thread Tools Rate Thread

Combining data from two fields

 
 
JKR in VA
Guest
Posts: n/a
 
      12th Aug 2009
I am using a message form in Outlook. I want the value of field "A" to equal
what is typed into "A", appended to what is typed into field "B".
In my trials, I cannot get the information typed into "A" to stay, it gets
removed and replaced by the data in "B".
Would someone please help me with this?

Thanks!!!!
 
Reply With Quote
 
 
 
 
Sue Mosher [MVP]
Guest
Posts: n/a
 
      12th Aug 2009
Try using the CustomPropertyChange event, as demonstrated at
http://www.outlookcode.com/article.aspx?ID=38.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"JKR in VA" <JKR in (E-Mail Removed)> wrote in message
news:B85E904D-725F-4019-8B3B-(E-Mail Removed)...
>I am using a message form in Outlook. I want the value of field "A" to
>equal
> what is typed into "A", appended to what is typed into field "B".
> In my trials, I cannot get the information typed into "A" to stay, it gets
> removed and replaced by the data in "B".
> Would someone please help me with this?
>
> Thanks!!!!



 
Reply With Quote
 
JKR in VA
Guest
Posts: n/a
 
      12th Aug 2009
Hi Sue,
Thank you for your help. This is beyond my ability level.
What I want to end up with is requiring the user of the form to fill out
either field "A" or field "B". I am using the text from these fields in the
subject line.
Is there a way with just the built in standard functions to achieve this?

"Sue Mosher [MVP]" wrote:

> Try using the CustomPropertyChange event, as demonstrated at
> http://www.outlookcode.com/article.aspx?ID=38.
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "JKR in VA" <JKR in (E-Mail Removed)> wrote in message
> news:B85E904D-725F-4019-8B3B-(E-Mail Removed)...
> >I am using a message form in Outlook. I want the value of field "A" to
> >equal
> > what is typed into "A", appended to what is typed into field "B".
> > In my trials, I cannot get the information typed into "A" to stay, it gets
> > removed and replaced by the data in "B".
> > Would someone please help me with this?
> >
> > Thanks!!!!

>
>
>

 
Reply With Quote
 
Sue Mosher [MVP]
Guest
Posts: n/a
 
      12th Aug 2009
I'm confused. The description in your latest message doesn't match what you
originally posted. Are you trying to do *both* validation and appending text
from one field to the value of another? Or are you taking the values of two
fields to create the value of a third?

FWIW, I have found over more than a decade of work, that VBScript behind a
custom form is not beyond anyone's ability. I would encourage you to read
through the examples and then ask specific questions if there's something
you don't understand.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"JKR in VA" <(E-Mail Removed)> wrote in message
news:FBDCDEF8-FD4C-43F4-B5A3-(E-Mail Removed)...
> Hi Sue,
> Thank you for your help. This is beyond my ability level.
> What I want to end up with is requiring the user of the form to fill out
> either field "A" or field "B". I am using the text from these fields in
> the
> subject line.
> Is there a way with just the built in standard functions to achieve this?
>
> "Sue Mosher [MVP]" wrote:
>
>> Try using the CustomPropertyChange event, as demonstrated at
>> http://www.outlookcode.com/article.aspx?ID=38.
>>
>> --
>> Sue Mosher, Outlook MVP
>> Author of Microsoft Outlook 2007 Programming:
>> Jumpstart for Power Users and Administrators
>> http://www.outlookcode.com/article.aspx?id=54
>>
>>
>> "JKR in VA" <JKR in (E-Mail Removed)> wrote in message
>> news:B85E904D-725F-4019-8B3B-(E-Mail Removed)...
>> >I am using a message form in Outlook. I want the value of field "A" to
>> >equal
>> > what is typed into "A", appended to what is typed into field "B".
>> > In my trials, I cannot get the information typed into "A" to stay, it
>> > gets
>> > removed and replaced by the data in "B".
>> > Would someone please help me with this?
>> >
>> > Thanks!!!!

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining Data from multiple fields Gil Microsoft Access Forms 6 3rd Nov 2008 03:41 PM
Combining Access Data Fields redlabel Windows XP 0 31st Mar 2006 06:43 PM
Combining data fields into one? =?Utf-8?B?a3dpbnRlcmI=?= Microsoft Access Queries 8 13th Oct 2005 05:53 PM
Combining data from 3 fields (colums) =?Utf-8?B?VG9tIFMu?= Microsoft Excel Misc 3 8th Apr 2004 04:15 PM
Combining data from 2 tables where the fields are different =?Utf-8?B?TmFuY3k=?= Microsoft Access 1 5th Apr 2004 07:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:34 PM.