Error: Enter Parameter Value

[Guest]

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

 

[Douglas J Steele]

What are the names of the parameters for which it's asking?

Might someone have altered the definition for one (or both) of the tables,
or deleted the Current_CRM table?

 

[Marcin]

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

=====================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM: http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net
==========================================================