Search results for query: *

Hi MajP, So do I remove the comma's ???? What does your reply mean

Hello, I had previously created an invoice email blast in Access 2007, now I have upgraded to Access 2010 the code is not working. The highlighted line is where I am getting an error message. Please advise : Private Sub Command52_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim...

I am trying YesClick at the moment, and researching Redemption. Thanks everyone

thank you anyway, you have helped me heaps !!

Thanks Duane, this works !! your talents are so very much appreciated !!! The emails are sent as expected - individual reports to each recipient however it is very slow - the second email takes a very long time - is there away to speed it up a little. Also I am still getting the allow / deny...

Glad its only 4pm, ok my sql view is the following with query name being qryEmailInvoices SELECT Members.MemberID, Payments.PaymentID, Payments.PaymentAmount, Payments.PaymentDate, Payments.PaymentMethodID, Year(Date()) AS [Year], MemberTypes.MemberType, MemberTypes.MemberDues...

Update .... After renaming qselEmailInvoice my emails did go however the report is still not looping and the recipients still get all the reports. After adding your omitted line "qd.SQL = strSQL" I now get error 3075 Syntax error missing operator in query expression ? sorry it must be getting...

Hi Duane, Thanks and my query name is qryEmailInvoices that both the form and the report relate to - I changed Set qd = db.QueryDefs("qselEmailInvoice") to read Set qd = db.QueryDefs("qryEmailInvoices") and I fixed the error message, however the email just hangs now. Stacey

Hello Duane, Decided to forgo the wheetbix and start coding this morning. I replaced your code and got the following error message "3265" item not found in the collection and I do not know anything about set qd - appreciate your help. Dim strSQL As String Dim qd As DAO.QueryDef Set db =...

Hello Duane, Thank you for replying to my query, I will try out your revised code. I am new to the forum and as I am in Australia, apologies for not being able to reply quickly due to time zone. Again thanks to all who are offering me solutions, as I have been searching and researching online...

Hello, I have created a membership dbase in Access 2007, in which I need to send out individual membership fees annually to about 326 members. I have set up a form based on a query that runs the report with information of an individual member. I am having difficulty in my code to loop through...

Hello, I have created the following code (copied the code) and it works great. I have 2 problems with it namely; 1. all recipients get all reports and 2. I have the annoying Allow Deny when clicking on the command send button. Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb...