Having trouble inserting text box date value into an SQL VBA insert

[Pack10]

I am building a rather large SQL insert statement.
I have a few date fields to insert values from text boxes on a form. I am having trouble getting the syntax correct.

 

[dhookom]

Can you share what you have so far?

From what I can see (not much), I don't see that you are using m/d/y and "#" as delimiters.

Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

The insert is very long. It works up to the txtUnAcknowledged field, when I add the txtLOA_Date I get syntax error every time I try something. Again, the value is coming from a text box on the form and I want to insert it into a date field in a table.



Values( " & Forms!frmTasksUpdate!txtUnAcknowledged & " , #" & Forms!frmTasksUpdate!txtLOA_Date & "# );

 

[Pack10]

My apologies, the code does work. I did not have a value in the text field. So my question is....if there is no value in the field which could be the case, how would I handle that...

 

[dhookom]

Either remove the field from the field list or insert Null without any quotes around it.

Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

So basically the SQL insert wont't work in this situation and I should use and "AddNew" and write the values to the fields and then do an update. Agree?

 

[dhookom]

As I stated, I use a SQL insert statement but substitute Null where I don't have a value to stick into the field.

Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

OK, thanks for your help.