how to import blank dates in word form to access




I managed to create a visual basic module in access that will import form
fields from a protected word form into access. When all of the fields are
filled out, it imports fine. The only problem I'm having is that there are
several date fields in the form and if any of them are left blank I get a
type mismatch error and can't import anything.

How can I get access to recognize a date field is blank and skip over it or
enter "null" for the value?


Jeanette Cunningham

How are you doing the import?
Are you saving the data from the word form as a text file and importing
Are you using vba to import one field at a time?
Is there any way to modify your code to use the Nz function to cope with
null values?

Jeanette Cunningham

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question