Recent content by HMarcks

Of course I am getting some type of corruption problem now...:banghead: It would be so nice if I had the time and resources to start all over with his database.

I ran into another problem with this. I added to the code so I could send out different letter types under specific circumstances. Now if the first instance has no record sets it is getting stopped on the first rs.MoveLast. If there are no record sets in any of the options I need it to skip down...

Got it! unbound text box starts out with no record then when I run the code it will populate it and in turn populate the report! Private Sub EMailAccLtr_Click() Dim MyDB As DAO.Database, rs As DAO.Recordset Set MyDB = DBEngine.Workspaces(0).Databases(0) Set rs =...

OK that makes sense I knew it was something wrong with he form moving to the next record because I never saw it change records. Thank you for helping me find a way to fix it.

ok so I added this DoCmd.GoToRecord , , acNext between the SendObject and the MoveNext and it worked! but was that what you meant for me to do? it seems like I am doing something redundant. It also jumps to a blank record at the end which may throw some of the users off but I guess I can...

Hi Paul, I have been digging through a lot of your posts where you have tried to help others with very similar issues. Sorry I haven't been able to decipher it all on my own and thank you for helping me. I thought the MoveNext was supposed to make the form go to the next record and therefore...

Good morning everyone, I haven't posted in awhile but am always browsing the information. Unfortunately I have been stuck for a few days on this one and I swear I had it working in a different application at one time. Working with Access 2007 and am knowledgeable enough to mess around with...