I
InfoPath101
MS 2007
I really need urgent help on this particular issue:
In my Infopath Form, I connect to my Access DB and pull back
information that falls into a drop down list. For that particular
field *I only want to show data that does not have any dates*, the
problem is I pull everything out of access including the ones with
dates for that field.
Is there a way to separate dates from no dates (empty or blank cells
in access)? I have tried putting "NULL" in my default value but I get
an error that reads "Value is not valid for field data type". If I
put a specific date in the default value I only pull that date out --
*I want to pull the ones with no date out.* I tried setting a rule
*field = is blank**. I have tried a million different combos and I
still cannot figure it out.
Please help I have been working on this way to long! Also I am not
that great with code so please be specific in your reply.
Thanks!
I really need urgent help on this particular issue:
In my Infopath Form, I connect to my Access DB and pull back
information that falls into a drop down list. For that particular
field *I only want to show data that does not have any dates*, the
problem is I pull everything out of access including the ones with
dates for that field.
Is there a way to separate dates from no dates (empty or blank cells
in access)? I have tried putting "NULL" in my default value but I get
an error that reads "Value is not valid for field data type". If I
put a specific date in the default value I only pull that date out --
*I want to pull the ones with no date out.* I tried setting a rule
*field = is blank**. I have tried a million different combos and I
still cannot figure it out.
Please help I have been working on this way to long! Also I am not
that great with code so please be specific in your reply.
Thanks!