Inserting Data From A Database Into A User-Defined Field

  • Thread starter Thread starter Rob
  • Start date Start date
R

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
 
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/
 
Back
Top