Search results

Hi, This is what worked for me. Private Sub Command18_Click() Dim oFilesys, oTxtStream As Object Dim txtHTML As String Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Dim OutlookAttach As Outlook.Attachment Set appOutLook = CreateObject("Outlook.Application") Set...

Thanks Galaxion, The penny has dropped, I will have to re-think the project and look into storing the path to the file's instead. Will just have to work out the other function of sending the record by email and attaching the file's to the email. Regards Ken

I understand the error msg, but on a new record with nothing in any field, how can it duplicate an existing value.

From what I have read the Recordset2 in Access is for the Attachment field. Don't I need that should it be Dim rsParent As Recordset and Dim rsChild As Recordset2

I Commented out the error handling, and tried it again and the system description of the error is: "Run Time Error '3820' you cannot enter that value because it duplicates an existing value in the multi-valued lookup or attachment field. multi-valued lookup or attachment fields cannot contain...

Hi, I'm trying to work out how to attach a word doc to the attachment field of a table when I add a new Record. The following code work's fine if I add it to the On Load Event on the Form, but the doc is attach'd to the first record. When I add the code to the Add New Record button, I get the...

Hi, thanks for the pointer, I have modified my code and everything is working as it should.:) Regards Ken

Hi, I'm very new to VBA and I don't know where to start looking for the answer to my problem. I'm working on a database for work that email's the current record after the form is completed. I have a attachment field in the table called Photo and some record's have a photo attached and other's...