[RESOLVED] error 3464? help-VBForums
Results 1 to 2 of 2

Thread: [RESOLVED] error 3464? help

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Dec 2011

    Resolved [RESOLVED] error 3464? help

    I cant save the this now to my database
    error 3464 "data type mismatch"

    here are the codes
    Set db = OpenDatabase(App.Path & "\database\database.mdb")
        db.Execute "update audit_log set timeout = '" & TimeValue(Now) & "', totaltime = '" & totaltime & "' where id = '" & timeid & "'"
    in my table(Audit_log) field2(timeout) and field3(totaltime) are text and my primary key field1(timeid) is autonumber

    my variables in vb timevalue(now) is string.
    totaltime is string
    time id is integer

    why I have data type mismatch??

  2. #2

    Thread Starter
    Junior Member
    Join Date
    Dec 2011

    Re: error 3464? help

    i forgot that my timeid in the update statement had single quotes which i had to remove to make the update work

    no need to post i already figured it out. how do i make this thread resolved.
    Last edited by langamer101; Feb 12th, 2013 at 06:50 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts


Click Here to Expand Forum to Full Width

Survey posted by VBForums.