Loading field desc with data from another table

[jeffreyswilson]

I have a table that was imported from an iSeries that has
approximately 300 fields. I would like to create the descriptions for
each field by looking them up from another file that contains the
field name and description. I belive that I need to use
CreateProperty
to do this but can't find a good example of this. I am a very
neophyte
VB coder, so I was hoping to find an example that I could just modify
to give me what I need. If anyone can link me to an example, I would
really appreciate it! Thanks in advance!

Jeff Wilson

 

[John Nurick]

Hi Jeff,

Allen Browne has a SetFieldDescription function (along with other
useful DAO code) at http://allenbrowne.com/func-DAO.html

 

[jeffreyswilson]

John

Thanks very much for the quick reply! I saw that code out there,
unfortunately I am not a VB programmer and don't know how to get the
field description from another file in order to pass it into this
function as a parameter. I think I am asking for too much here and may
need to go another route. I thought that if there was sample code that
did exactly what I wanted (chaining out to another table to get the
value for the description) that I might be able to change it to use my
specific information...but I doubt that will happen. Thanks again for
your help.

Jeff