alexkeel79
MIS
Hello all,
I'm new to Access DB modules so I'm not sure what is going on. I created a module that imported data from a word form. Everything works fine except when importing date/time information. If the field in the table is type date/time and the field in the form is null then I get the following error "Access DB error -2137352571: Type Mismatch". If the field in the form is filled in with a properly formatted date the import works fine. Also if I change the data type of the field in Access to Text the import works fine. Does anybody know how to fix the code so that if the date/time field in the form is blank then the module would just import null into the table for the date/time field? Here is the line of code from the module:
!expDt = doc.FormFields("expDt").Result
I'm new to Access DB modules so I'm not sure what is going on. I created a module that imported data from a word form. Everything works fine except when importing date/time information. If the field in the table is type date/time and the field in the form is null then I get the following error "Access DB error -2137352571: Type Mismatch". If the field in the form is filled in with a properly formatted date the import works fine. Also if I change the data type of the field in Access to Text the import works fine. Does anybody know how to fix the code so that if the date/time field in the form is blank then the module would just import null into the table for the date/time field? Here is the line of code from the module:
!expDt = doc.FormFields("expDt").Result
