Member Avatar for IT_Student_604

im having problem og this code...

txtTimeOut.Text = Format(Now, "h:mm:ss tt")

            constr = "UPDATE tblDTR SET EmpName='" & txtName.Text _
            & "', Date_in='" & Format(Now, "MMMM d, yyyy") _
            & "', Time_in='" & txtTimeIn.Text _
            & "', Date_out='" & Format(Now, "MMMM d, yyyy") _
            & "', Time_out='" & txtTimeOut.Text _
            & "'WHERE EmployeeID=" & txtEmpID.Text

im having an error of datatype mismatch in criteria expression i checked the table i made and it has the same name and right rows to insert data into.. i just can't find the problem in my code.. can someone help me?..

btw im doing a dtr system the code shown above is for the time-out of an employee..

  • 4 Contributors
  • 8 Replies
  • 195 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by Mike Askew
Member Avatar for IT_Student_604

please.. i need help so badly.. :(

Member Avatar for Ranx 
& "'WHERE EmployeeID=" & txtEmpID.Text

try

& "'WHERE EmployeeID='" & txtEmpID.Text & "'"

if EmployeeID is a text field.

also try putting a spce between "'" and "where"

Member Avatar for IT_Student_604

employee id is a number field...
how is it?

Member Avatar for IT_Student_604

employee id is a number field...
how is it?

Member Avatar for Jx_Man

check your input with your data type in database.
like date, your input must be suitable with database type.

Member Avatar for IT_Student_604

im sorry, yes its a textfield.. i just got confused.. thnks for the reply..

Member Avatar for IT_Student_604

i just get a syntax error.. :(

Member Avatar for Mike Askew

What is the exact syntax error? and what input are you entering into the textbox?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.