Datatype Mismatch (1 Viewer)

[abbaddon223]

Hi,

I have the following SQL code running via VBA. I keep getting a datatype mismatch error, howevr the field I am referencing, and using as the qualifyer to update the record is Number.

Any help greatly appreciated!!!!

Dim Ref As String
Ref = Forms!Frm_WB_Login.Form!Frm_Callbacks_Due![callback_id].Value

Dim MySQL As String

MySQL = "UPDATE vicidial_callbacks SET vicidial_callbacks.status = 'INACTIVE' "
MySQL = MySQL & "WHERE vicidial_callbacks.callback_id = '" & Ref & "';"

DoCmd.RunSQL MySQL

 

[namliam]

perhaps you should remove the ' around the ref in the SQL?
Instead of
MySQL = MySQL & "WHERE vicidial_callbacks.callback_id = '" & Ref & "';"
...
MySQL = MySQL & "WHERE vicidial_callbacks.callback_id = " & Ref & ";"

 

[pr2-eugin]

If it is Number why have you declared it as String?

Dim [COLOR=Red][B]Ref As Long[/B][/COLOR]
Ref = Forms!Frm_WB_Login.Form!Frm_Callbacks_Due![callback_id]

Dim MySQL As String

MySQL = "UPDATE vicidial_callbacks SET vicidial_callbacks.status = 'INACTIVE' "
MySQL = MySQL & "WHERE vicidial_callbacks.callback_id =[COLOR=Red][B] " & Ref[/B][/COLOR]

DoCmd.RunSQL MySQL

 

[jdraw]

It appears that Ref is a string. And that callback_id is number ----???

OOops: I see others have posted while I was typing.

 

[abbaddon223]

Hi all,

Thank you for your kind responses - I've now got this working with your help!!

Thanks!