Search results

  1. Y

    Solved save query results to use even after criteria changes

    I"m using a Recordset to select records to be updated using Do ANd Loop The Recordset gets the records based on a complex Query. the problem is that each time the loop statment is passed - it refreshes the query criteria and some records previously part of this recordset waiting to be updated...
  2. Y

    Recordset - too few parameeters, expected 2

    It worked!! Thank You!!! p.s. do I understand correctly that you prefer DAO over ADO?
  3. Y

    Recordset - too few parameeters, expected 2

    no. the error is in the code Set Recordset = fDAOGenericRst(Query1) I guess the problem is in the fDAOGenericRst function which you are a lot more familiar with then me. thanks a lot! On the form that sets of this code i added a textbox called QueryString, to be able to view the full string...
  4. Y

    Recordset - too few parameeters, expected 2

    tried and works well!
  5. Y

    Recordset - too few parameeters, expected 2

    here is the full string that Query1 represents, maybe something is wrong with the string. SELECT TDID, ContactID, TransactionDate, AdditionAmount, FundId, SpecialReceipt, RunningFund_ContactTotalDates, RunningContactTotalDates, ReceiptNumber From ReceiptsToCreateTotals_Dates WHERE ContactID...
  6. Y

    Recordset - too few parameeters, expected 2

    Changed Query to Query1 and Recordset to Recordset1 but I"m getting the same error.
  7. Y

    Recordset - too few parameeters, expected 2

    Added, but now it errored on (Query) with the message in the picture attached Added,
  8. Y

    Recordset - too few parameeters, expected 2

    visual basic for application microrsoft access 16.01 object library OLE Automation Microsoft CDO for Windows 2000 library
  9. Y

    Recordset - too few parameeters, expected 2

    yes, when I used fADOGenericRst the line ending with adLockOptimistic when I used fDAOGenericRst the line ending with dbOpenDynaset
  10. Y

    Recordset - too few parameeters, expected 2

    Thanks for the responses, but the error wasn't received on this line , rather on the code of the link: CODE SNIPETS - http://www.accessmvp.com/thedbguy/codes.php?title=generic mentioned above. to clear out the problem I"m adding the part that errors here - this part is highlighted when the error...
  11. Y

    Recordset - too few parameeters, expected 2

    I'm using a recordset in access vba to update specific records with an update command. I'm receiving this error mesage too few parameeters, expected 2 i looked it up and found that the DBGuy suggests to add this link to a module and then call on it...
  12. Y

    Use string variable in sql update statement

    Works! Thank You! Very important to know!
  13. Y

    Emailing with Access

    Attached DB-2, buit using your Demo. I omitted the fields user name , password, and from from the EmailConfiguration table for privacy reasons. when I try using it i receive the message 3749 Fields Update Failed ...
  14. Y

    Emailing with Access

    instead of deleting all sensitive info, I created a new DB that represents the old one perfectly. Attached below.
  15. Y

    Emailing with Access

    does send object need outlook?
  16. Y

    Emailing with Access

    Thanks! :)I was hoping the DBguy will take part of this conversation:) I have a Access DB for a organization. it contains a Donors Table and a Donations Table, with a field DonorsID in the Donations Table that is related to the Donors Table. As assumed in the donors table there is an email...
  17. Y

    Emailing with Access

    very nice demo but dosent have an option to send individual receipts to individual donors
  18. Y

    Emailing with Access

    I would like to send out individual receipts to individual donors with access vba. I have a query containing all the info needed, I searched around it looks like there are a few ways around to make it happen. I would like it to work with out outlook installed. I would greatly appreciate any hep...
  19. Y

    Helo

    I"m not new to access but lately i"m trying my way thru emailing with access, which is not so easy as it seems. I deeply appreciate the time & effort others put in to help!
View older results
Back
Top Bottom