Inserting Data From A Database Into A User-Defined Field

[Rob]

I have added a field to a Contact form in Business Contact Manager called
Test Field.

The issue I am having, concerns when I try to insert data from a database
into the field using a piece of VBScript.

My code to insert the content is:

if isnull(objrs("Member Name")) = false then .TestField = objrs("Member
Name")

I am wondering if it is the name of the field I am looking up in the form
(.TestField) and whether or not this is the correct VB name for the field,
Test Field.

If this is the case how do I find out what the VB name is for user-defined
fields?

Any advice would be much appreciated

 

[Luther]

I have added a field to a Contact form in Business Contact Manager called
Test Field.

The issue I am having, concerns when I try to insert data from a database
into the field using a piece of VBScript.

My code to insert the content is:

if isnull(objrs("Member Name")) = false then .TestField = objrs("Member
Name")

I am wondering if it is the name of the field I am looking up in the form
(.TestField) and whether or not this is the correct VB name for the field,
Test Field.

If this is the case how do I find out what the VB name is for user-defined
fields?

Any advice would be much appreciated

I suspect that you can't access an object's custom fields directly
(with a dot) in Outlook's object model. Instead, I would look for
those fields in the object's user fields array. And you may need to
add that field to the object, if it doesn't already have a value.

Luther
http://beyng.blogspot.com/

 

[Rob]

Thanks Luther

Could you give me an idea on how I would go about doing that

Thanks

 

[Luther]

Thanks Luther

Could you give me an idea on how I would go about doing that

Thanks







- Show quoted text -

Here's an example of accessing the UserProperties array:
http://beyng.blogspot.com/2008/03/setting-user-property-on-new-account-in.html