Search results for query: *

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

Thanks for correcting that for me. I tried it and got the same error though. The sql now reads: If Me.STATUS = "IN HCO" And IsNull([Me.CASE NO]) Then Thanks.

Hi, I have a form that is running the following on close event when I get the runtime error 2465 for cannot find the field. Here is the code I have: Private Sub Form_Close() If Me.STATUS = "COMPLETE" And Me.[CASE NO] Is Null Then MsgBox "CASE NO IS REQUIRED IF THE ACCOUNT IS COMPLETE"...

I figured it out. it was the "write" option on the security for certain user groups in explorer.

I have a query that captures the userid when then enter a form in Access 2003 and appends that into a logon table so i can see who logs on and when they leave as well. One user gets the "operation must use an updateable query error" error when he opens the DB. I coulbn't find an answer to why...

Thanks PHV! That worked perfectly!