Thread: SQL code works in Access SQL window but not in VBA SQL code
View Single Post
  #14  
Old August 10th, 2008, 06:44 PM posted to microsoft.public.access
bcap[_2_]
external usenet poster
  
Posts: 260
Default SQL code works in Access SQL window but not in VBA SQL code

"Michael Gramelspacher" wrote in message
...
On Sun, 10 Aug 2008 09:30:25 -0700 (PDT),
wrote:


try this

dbs.Execute _
" a.AAA_UIC, a.ACRN, a.AMT, a.DOC_NUMBER, a.FIPC," & _
" a.REG_NUMB, a.TRAN_TYPE, a.DOV_NUM, a.PAA," & _
" a.COST_CODE, a.OBJ_CODE, a.EFY, a.REG_MO, a.RPT_MO," & _
" a.EFFEC_DATE, a.Orig_Sort, a.LTrim_BFY, a.LTrim_AAA," & _
" a.LTrim_REG, a.LTrim_DOV, a.AMT_Rev, a.CONCACT" & _
" INTO [CHOOSERev] FROM [CHOOSEData]" & _
" WHERE (((a.TRAN_TYPE) IN ('1K','2D'))" & _
" AND ((a.LTrim_REG) '7'));"

How can he execute that string, it isn't even a statement? There's no
SELECT...