How to turn off prompt when running append query from code

[GraeagleBill]

I'm writing an import function in one of my apps. Table rows are being added my the 100's. How do I turn off the prompt when each row is to be created"





Here's the 1st of the SQL command strings:



Good grief! How do I get insert image to display the images at their actual size?

[GraeagleBill]

Here's the first of many SQL statements, as copied from the immediate window (debug.print):

INSERT INTO Registry([FamilyID], [RegAs], [LastName], [FamilySort],[FirstName],[Address],[CityState],[Zip],[Select])Values(850, "Spouse","","2","Bev","80065 North Street","Scottsbluff, NE","69361-5739"," ")

[nigelbloomy]

If you are running this query from a macro or VBA code you can add the line DoCmd.SetWarnings False just before the query starts and then put DoCmd.SetWarnings True just after the query runs.

[pbaldy]

Alternatively, use the more efficient Execute method:

http://www.baldyweb.com/SQLWarnings.htm

[GraeagleBill]

Thanks, that cleared up the issue.
Bill

[GraeagleBill]

Hi Paul,

I had already noticed that I should be using CurrentDb.Execute. Since I had made both changes at the same time, DoCmd.SetWarnings and CurrentDb.Execute, I didn't realize that using CurrentDb.Execute would run without the warnings anyway.

As an aside, what is the answer to my question about displaying images at their original size?

Bill
(PS) HOT HOT HOT!!!!