Recent content by Hayes8052

Thank you Paul for your assistance. This became to complex and went for the option to design certain reports for the regions. Once again thanks for your efforts.

Hi pbaldy, I am attempting the loop but now I get the following error and not sure how to fix it. error 2295 Run time error. The comment is unknown message recipients. Below is the code I am using. Private Sub Email30_Click() Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sToName As...

Good day pbaldy, Thank you. I will give it a shot. Appreciated.

Good day pbaldy, Thank you for your feedback it is appreciated. I am new to VB and not sure how to go about building a string. I would need to build the string around the the Email address as that is linked to the region/Business unit responsible for the contract. any assistance would be...

Good day, I am using Access 2010. I am still a beginner in VB Access and self taught. The below code works great. I have 2 problems and would like some assistance as to how to fix them. 1. When there is more than on contract for that region I would like to consolidate all the contracts into 1...

Good Day, I am sort of an intermediate with Access. The last time I did something in Access was in about 2006. Now I am back into it. The reason why I am here is I am mostly self taught and my VB is at beginner level and will be seeking help with assistance in VB. Regards Doug