Search results

Jdraw, Jiri, & Dale, I add the debugging statement and stepped through the code to see what values exists where and when. I added MyRS.edit and MyRS.update before and after the Me!E_Sent = Now() and it works perfectly! I am starting to get the hang of this once again... :) Thank you very...

Hi jDraw, Thank you for your quick reply! It is actually Me!Email_Sent, but since I am a new member I cannot spell out email. I am trying to update the Email Sent date and time field whenever the automated email is sent to a customer based on set criteria. Since it has been quite a few years...

I am trying to get my E Sent field to update whenever the automated Email button is clicked on the Customers form; however I running into a brick wall and don't know what I am doing wrong :banghead: I was able to get it to update the first record, but not any after. Option Compare Database...

Hi Paul, I took your advice and took out the MoveFirst line and changed Set MyRS = MyDB.OpenRecordset("SELECT * FROM MailingList WHERE [Category] = 'X'")... It worked like a charm! I cannot thank you enough! Have a great day! sarguzm :)

Thank you Paul, I will try putting it after the loop. sarguzm

Since it has been quite a few years, I am a bit rusty... I am trying to get Access to send automated emails based on certain criteria. I accomplished the sending automated emails part, but not the based on certain criteria part & I have been working on this far too long and just can't figure out...

Hello Access People, I work in the accounting field and haven't used Access in quite a few years! Although I am a bit rusty and will need some guidance.. I hope to update my Access knowledge and be able to help someone else... Thanks, sarguzm