Your query seems wrong
<pre>strSTMT = "INSERT INTO TABLE_ONE (T_NUM, T_BATCH_ID,CREATE_DATE,LAST_UPDATE_DATE) " & _
"SELECT '" & iStoreNum & "', T_BATCH_ID,SYSDATE,SYSDATE FROM Tbl_BATCH a" & _
" WHERE T_BATCH_TYPE = 'C'" & _
" AND T_BATCH_AUTO_ASSIGN = 'Y'" & _
" AND (Missing Column Name) NOT EXISTS (SELECT ROWID FROM TABLE_ONE b WHERE T_NUM = " & iStoreNum & _
" AND a.T_BATCH_ID = b.T_BATCH_ID )"
You missed a column name in where condition, Indicate a correct column name instead
(Missing Column Name)
Let me know if it will not going to work.