[AccessD] Actually using the email
jwcolby at gmail.com
Sat Aug 21 09:26:39 CDT 2021
Sorry, I somehow managed to send that last email before it was finished.
It turns out you can ask a table if it has a field by something like
Dim strFldName as string
StrFldName = rst.fields("SomeFieldName").Name
If the field exists, then strFldName will contain " SomeFieldName". If the
field does not exist then the code will error. If the code errors, then we
build the field.
Remember that I created a clsKeyVal which has the field name and value.
KeyVal pairs are common in programming. So that class is:
Option Compare Database
Public mKey As String
Public mVal As String
Using this simple class to hold the two pieces and strong these class
instances in a collection gives me the data required to automatically build
a table even if new fields are added, with no further effort on my part.
Once the table is built / new fields added, I also have the data to build a
new record with all the data from the email.
John W. Colby
More information about the AccessD