I need help please. I'm new at VBA and don't understand what RunSQL mead or does. Also have a problem with a some code. Sometimes it works and sometimes it does not work.

The first thing I do is create a string :

SQL ="Delete * from tblpatset_Temp where (testnumber='11.2.3R');"

This is the string that is sent to a routine call RunQuery: ie;

Sub runQuery(sql As String)
   On Error GoTo Error_RunQuery

   DoCmd.SetWarnings False
     MsgBox sql 'I verify the correct sting
     DoCmd.RunSQL sql
   DoCmd.setWarnings true

Exit RunQuery:
  Exit Sub

Error_RunQuery:
   more error code

Sometimes when the string returns from RunSQL it goes to DoCmd.SetWarnings True then exit sub.

Sometimes when the string returns from RunSQL it goes to Error_RunQuery and the delete does not happen.

Why??? What does RunSQL return? A true/false statement?

Any ideas?

The RunSQL method does just that, it runs the SQL query you've setup with the variable called "SQL". And because you've turned off the warnings prior to RunSQL, nothing will be returned. The query will run, and in the case of your example, delete the records that match the criteria from the specified table. If you comment out the line 'DoCmd.SetWarnings False', you should receive a message telling you the number of records that will be deleted and that if you proceed, the action cannot be undone. But it is possible the database properties may be set to not display this warning. To check this go to Tools|Options...|Edit/Find and check the settings in the Confirm group.

Darrell L. Embrey

I commented out the 'DoCmd.SetWarnings False' and when the program returns and works correctly it will display a message telling me the number of records that will be deleted. However, it still comes back and jumps over the 'DoCmd.SetWarnings False' and goes to the Error_RunQuery: and not delete the record.

I found out why the items are not getting deleted when I run a DoCmd.runSQL DELETE * query. The table that it is using is called "tblTemp" and is used to temporarily store items until done then the items will tranfer to a static table. It turns out that if there is more the one item of the same name the system gets confused and does not know which one to delete. I don't know why this is. Also, the table is linked and don't know how to find out who it's linked to. I tried deleting all 800 records but it will not let me delete 34 of them. I suspect this 34 are linked to another table. I don't know.

Any help will be appreciated.

Rick