Recent content by BV874

I switched to .htmlbody and used "<br>" instead of the vb line breaks and it worked. Thank you both for your assistance.

olFormatRichText and the Outlook option did not work. My longest line is 164 characters. I'm going to try .htmlbody instead of .body to see if works better in that format. Thanks.

Hi MakeItSo, I do get the line breaks, but there is an extra break that appears in the e-mail on long text. When I select it to manually delete it is not there. I think it may be a 1.5 line spacing issue, but it only appears on the long text. See below for an example: Dear Test Account, Here...

Hi, I have the following code that creates an e-mail from a query if multiple parameters on a form are met. When the email is created the information from the recordset is listed line by line. If the EmailText string is over 120 characters it creates an extra line break. I have tried vbnewline...

That worked perfectly, Thanks so much!

Golom, I tried the code and it is returning no results. Thanks.

I think what I need to do is find a way to number my query results. (1,2,3,4..) so I can inner join them in each table along with CUS_NUM. First Query: SELECT CHECK_REGISTER.CUS_NUM, CHECK_REGISTER.TRAN_DATE INTO TEMP_MISSEDPAY01 FROM CHECK_REGISTER ORDER BY CHECK_REGISTER.TRAN_DATE; Second...

I just tried making a temp table of all transactions. Then a second temp table with the min TRAN_DATE grouped by customer. I then deleted the min transactions from the first temp table using a delete distinctrow query. I then linked the original table CHECK_REGISTER with the revised temp table...

I tried AdjDate: DateAdd("m",1,[TRAN_DATE]) and then took the difference between TRAN_DATE and AdjDate but then realized it would not work because of payments on different days, missed payments, and I was going in the wrong direction. I have been unable to come up with a method since. Any...

Hello, I am trying to create a query on a payment history table that shows the time in between payments to locate missed payments. Each customer is required to make a payment each month. Each payment is stored in a row in the table [CHECK_REGISTER]. I need to group the query by [CUS_NUM], and...

Thanks PHV!

Hello Everyone, I am receiving a compile error on the following code for method or data member not found. Any help would be greatly appreciated. Thanks! Dim Mysql As String Dim RS As Recordset Mysql = "Select [CountOfCUS_NUM] from [tblUploadDuplicates]" RS.Open Mysql, CurrentProject.Connection...

Thank you PHV, you are absolutely right! I had to change it to the unload event.

My control source was CASE_NO and my field name was CASE NO so I entered it incorrectly. Thank you for your help!

My mistake,it reads the following. If Me.STATUS = "IN HCO" And IsNull(Me.[CASE NO]) Then