Recent content by itsmedd

  1. I

    Question Executing statement from VBA Code

    Bob, Will it make difference in the way i am executing this statement with Recordset. rs.CursorLocation = adUseClient rs.Open strSQL, rsconn, adOpenKeyset, adLockPessimistic
  2. I

    Question Executing statement from VBA Code

    Bob, i am getting the same error message with no luck.
  3. I

    Question Executing statement from VBA Code

    yes i am using SQL Server and removing the ts nor the {} didnt help me resolve the issue.
  4. I

    Question Executing statement from VBA Code

    those {} are for my Start and End date timestamp without which my select statement wouldnt work.
  5. I

    Question Executing statement from VBA Code

    I even tried the below statemen with target table fields, still the same error msg. Insert into Daily...
  6. I

    Question Executing statement from VBA Code

    Bob, I have enclosed all the fields in select statement in [] and still getting the error msg lexical element not found : <Identifier>. I dont think its problem with the statement as i am able to execute the select statement, i am getting this error only when i include the Insert part with it...
  7. I

    Question Executing statement from VBA Code

    Thanks for all your efforts and support, i am still unable to get this working. :(
  8. I

    Question Executing statement from VBA Code

    Yes i did execute the same query from access and its giving me the same error message. I do have the field name with _ in our Remedy database
  9. I

    Question Executing statement from VBA Code

    i did try the debug.print strSQL with no output and also i have corrected the same issue but still i am getting the error message "Runtime Error - 2147467259 (80004005)river]Expected lexical element not found: <identifier>. Please help
  10. I

    Question Executing statement from VBA Code

    Hi, Thanks for the quick response, yes i did post in vba module but felt that its more visible in general forum. I did try the below statement but still getting the same error message. "Insert into Daily...
  11. I

    Question Executing statement from VBA Code

    All, I need experts advice on resolving this issue, i am trying to extract data from a sql server database on to an access database for my custom dashboard. I am getting the "Runtime Error - 2147467259 (80004005):Driver]Expected lexical element not found: VALUES" while i am trying to execute...
  12. I

    Executing Query in VBA

    Thanks a lot Keith.. this worked out perfect for me.. and i got to know were is was making mistake... Thanks for your suggestions Ken.
  13. I

    Executing Query in VBA

    Keith, its giving me an err message Microsoft Access cannot find the object 'qryExample'. Any thing that i need to do other than this query. Appreciate all your help on this...
  14. I

    Executing Query in VBA

    Keith and Ken, I am getting the attached error message when i try with the suggested code.
  15. I

    Executing Query in VBA

    Ken.. i works perfectly fine..i had checked it before i started of with code. Is there something that needs to be done with the Object ???
See more
Back
Top Bottom