Search results

  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 ???
  16. I

    Executing Query in VBA

    Hey Ken ,, Thanks for your quick response.. PFB my small select case code.. Private Sub View_Click() Dim StrMon, StrQry As String StrMon = [Forms]![Month]![MonthCMB].[Value] MsgBox StrMon Select Case StrMon Case "Jan" StrQry = "SELECT Software.BXG_Desc, Software.Application...
  17. I

    Executing Query in VBA

    Hi, I am a beginner in access. I am trying to execute the below query through VBA on a click event on a Command Button in a Form. I am taking input parameter from Form, based on which I want the query result( dynamic Query Parameter). I getting the attached error message Please help me out...
  18. I

    Compare Tables in Access

    Thanks a lot for all the suggestions...PSu pls let me know if you happen to accomplish this VBA script as i would also need this code and i am not that comfortable with Code.Appreciate all the suggestions provided.
  19. I

    Compare Tables in Access

    Hi, I need to compare 2 tables with Same Structure in a Database and pull out records that are not matching in both the tables. As anyone done similar task in Access 2002, if so please let me know how this can be accomplised.
  20. I

    Disable Datasheet from Poping up after Query Execution

    Thanks alot Bob... I am able to accomplish this task.Appreciate all your assistance on this.
Back
Top Bottom