INSERT text box value to table

[BrianLe]

In Access 97, I'm trying to use an SQL statement to insert the "value" of tbx1 to tblSchedule. In one case the "value" is a Date and the other it is Text. I believe my problem is what to put after the "." in tbx1." ". The Insert statement is also used to insert other combo box and list box values. That part works OK.

SQL = "INSERT INTO tblSchedule (DateTime) " & _
                 "VALUES (" & DQ & tbx1."????" & DQ & ");"

Thanks, Brian

 

[PHV]

You may try this:
SQL = "INSERT INTO tblSchedule (DateTime) " & _
"VALUES (#" & tbx1.Value & "#)"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BrianLe]

I get a syntax error in INSERT INTO statement.

 

[PHV]

DateTime is a reserved word:
SQL = "INSERT INTO tblSchedule ([DateTime]) " & _
"VALUES (#" & tbx1.Value & "#)"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BrianLe]

What you suggested works if I use it all by itself, but when I try to add it to my list of other commands I can't get it to work.

DQ & cbx2.Column(0) & DQ & "," & _
(#" & tbx1.Value & "#)"

Thanks, Brian

 

[PHV]

Any chance you could post the WHOLE SQL you want to build, explaining clearly which fields are numeric, text or date ?