Search results for query: *

Walt, Yes, the best way to accomplish this functionality is to use VBA. Create a procedure that opens a recordset of Table 1 and another of Table 2. Start looping through each record in Table 1 until you reach the end of file(EOF). While processing each record check Field5 to determine the...

tbaguio, The only thing I know that can to help is that when you are creating the email, instead of using ex. mailItem.Body = &quot;My Text&quot; use mailItem.HTMLBody = &quot;<B>My Text</B>&quot; I haven't tried it but the method is there and there may even be a mailItem.rtfBody as well...

chsu, After looking at your code quickly the only question that I have is did you try using a Do While Loop instead of Do Until. If you change your loop to: Do While Not rsStruc.EOF You may get the results you want.

mfd777, Is the memo field a bound field on the second form? If it is this is causing the problem. The second form should probably be completely unbound and Form_Open and Form_Close code should be written to populate the memo field and save any updated results back to the recordset on the parent...

One of our developers left the company and converted a mdb to a mde. Is there any way to reverse engineer the mde file so we can continue development.