Recent content by Bobbles

guitarzan. I use the free SGrid2, so I don't have that problem (when there are no records). What you could do is add a frame, with a nice central Label displaying this text - "NO RECORDS TO DISPLAY" You can size and position the frame in the IDE, and set it's Visible property to false. Then...

Have you tried my suggestion ? All I am saying is, if you have a rs with records, they will load , if you only use code (no binding). Regards, Rob

I have used Thunderbird to create a message, and TB has also embedded (base64) a bmp file like a letterhead across the top. It works well. (There is no attached file, and no link to the web to get the image) If I copy the email source into a file, I assume I can do the trick described by Dick...

I use the free SGrid2, but the concept should be the same. If you keep it simple and do all the loading, clearing, loading, etc, with code (no binding please) it should be impossible to have the problem described above. If you close the rs, and set it to nothing, and then send your next SQL...

Personally I evolved away from binding years ago. As Buffy would say 'that would be bad'. Have one Sub for configuring your grid. And another for Grid_AddData. In the latter, you clear the grid, then navigate through your recordset, adding rows, and populating the cells. This allows you to...

Thank you both, for your response, I will give that a try. Regards, Rob

Hi, I have vbSendMail working. I am attempting to have the body of the email as HYML instead of plain text. Could you elaborate on how you achieved that ? Thanks, Rob Crombie robhp AT iprimus.com.au PS My dream is to have 'email merge', which I believe I can achieve, after I solve the text...