Search results

ReclusiveMonkey, This may be exactly what sendObject is for, and I keep looking at the help system. But I have yet to find anything which refers to an attachment or a text file. The AcSendObjectType choices refer to Access Objects, not files on the hard drive. If I use an Access Object, it does...

Is there a way to attach a file to an e-mail using DoCmd.SendObject? I'm using SendObject because I can't guarantee that the users machine will include Outlook. The file I want to attach is a simple .CSV file on my local hard drive. Thanks for any ideas. James

Perhaps you could include your sendObject code. "However the problem here is that everytime someone sends the email it sends every single report that has been created." Surely you mean that it is sending the report for all records? Not every report. If the report is only used for this form...

I am creating a 1 to many relationship between 2 tables (in the back end). I want the record on the parent table to be optional (0 or 1 record). While creating the relationship programmatically I get an error. "You cannot add or change a record because a related record is required in table...