C
Che
During my absence, something happened to my database that it is now asking
for parameter values.
Here is the error log it shows me...
Function DoUpdateCRM()
Dim SQL As String
SQL = "INSERT INTO Master_List ( ID, [Last], [First], Address1, Address2,
City, State, Zip, Email, Phone ) SELECT Current_CRM.ext_relation_id,
Current_CRM.last_name, Current_CRM.first_name, Current_CRM.addr1,
Current_CRM.addr2, Current_CRM.city, Current_CRM.state, Current_CRM.zip,
Current_CRM.email, Current_CRM.phone FROM Current_CRM LEFT JOIN Master_List
ON Current_CRM.ext_relation_id = Master_List.ID WHERE (((Master_List.ID) Is
Null))"
DoCmd.RunSQL SQL
for parameter values.
Here is the error log it shows me...
Function DoUpdateCRM()
Dim SQL As String
SQL = "INSERT INTO Master_List ( ID, [Last], [First], Address1, Address2,
City, State, Zip, Email, Phone ) SELECT Current_CRM.ext_relation_id,
Current_CRM.last_name, Current_CRM.first_name, Current_CRM.addr1,
Current_CRM.addr2, Current_CRM.city, Current_CRM.state, Current_CRM.zip,
Current_CRM.email, Current_CRM.phone FROM Current_CRM LEFT JOIN Master_List
ON Current_CRM.ext_relation_id = Master_List.ID WHERE (((Master_List.ID) Is
Null))"
DoCmd.RunSQL SQL