Search results

  1. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Here's the SQL for the Import query that has parameters in it. INSERT INTO tblClaimsWorkingTableTEMP ( ClaimNumber, AuthNumber, DateOfServiceFrom, DateOfServiceTo, ProviderCIMID, PayeeName, FEIN_SSN, DateReceived, MemberID, YouthName, DxCode, DxCode2, DxCode3, DxCode4, ServiceCode...
  2. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    I am so sorry but now it's giving me this error message on the .Value
  3. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Hi - I just realized it's probably because the import query is reading and appending records from a table that is linked from a SQL database! Maybe it's that table it's not recognizing because it's linked? I am guessing....
  4. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    UGH -
  5. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    FYI I just removed the parameter in the Delete query and it's still giving me the same error message. DELETE tblClaimsWorkingTableTEMP.* FROM tblClaimsWorkingTableTEMP;
  6. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    YES!!
  7. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    I changed the .Execute "qryDeleteRecsFromTempIMPORT" and it's still giving me the same error message. The name is correct.
  8. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Ugh...I am sorry but I copied and pasted your latest VBA code and now I am getting this:
  9. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Hi Again - the user inputs a date range on the Form and when they click Import button is should not kick off this VBA code. I need the Form field date ranges in order to select the correct range of records to import. So should I copy your new code? Thank you! Dang do you know your VBA code and...
  10. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    So if I modify the VBA and use the DoCmd statement it runs the queries, however, it always falls through the If .recordsAdffected = 0 message and displays 'No claims were imported from CYBER.'
  11. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    It's failing on the .Execute statement. the yellow highlighting isn't showing.
  12. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Hi - I tried this VBA code but it's failing on the .Execute
  13. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

  14. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Hi again - So I made some adjustments to the VBA code. It seems to prefer the DoCmd better than execute. If I comment the Call msgbx function it runs, however it drops into the CurrentDb.RecordsAffected = 0 message when there were 8 recs imported. When I remove the comment and let it execute the...
  15. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    I literally copied and pasted the query name into the code. it's not misspelled.
  16. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Good Morning - the vba code is not working. I am getting this message when I run the process
  17. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Here's the SQL string of the query qrySelectClaimsFromCYBER SELECT dbo_tblClaimsAttestation.claimsId, dbo_tblClaimsAttestation.AuthNumber, dbo_tblClaimsAttestation.ServiceDateFrom, dbo_tblClaimsAttestation.ServiceDateTo, dbo_tblClaimsAttestation.CIMID, dbo_tblClaimsAttestation.ProviderName...
  18. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Here's my VBA code
  19. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Thank you for your quick reply. I am receiving this message when I click the form button (on click event) to execute the macro Here's my embedded macro Here's my function (vba module) Also, how will I display messages based on the record count? So if the record count = 0 display message...
  20. A

    Solved Import process runs append query: is there a way to alternate the message depending on the record count?

    Hi - I have a macro (mcrImportClaims) that is attached to the OnClick Event of a button that resides on a Form. This simple macro executes an append query (qryImportClaims) that reads records from a SQL table and appends them to my Access table. The macro runs a delete query first, then the...
Back
Top Bottom