Search results

Ignore that ... all working now MANY THANKS !!!

Hi Stopher, Thanks for that , i'm a little confused what you mean by myFormBoxName ?

Hi all ... i know this has probably been dredged up before but I am struggling with this and I need an urgent fix. I am trying to email a single record in a report. But no matter what I have tried it always produces a report of all recordests. I just need it to send the report that is...

Many thanks Barry. I finally found some script that works but ... I still need to alter the code to filter a single record... my current code is: Private Sub sendMail_Click() On Error GoTo Err_sendMail_Click Dim strWhere As String Dim stDocName As String strWhere = "fldID" stDocName =...

I'm trying to get code my access 2007 database so that it can email out a single recordset in a report or other format. Filtered by an ID field. I'm pretty new to this and I understand that SendObject is the best method. However, I have tried hacking and slashing various scripts off forums...