Thanks for the reply Minty,
I am new to all this so sorry if i'm asking silly questions. I have got a little confused with the code you've gave me. where exactly should it go? and will I need to edit some properties on my report for it to work?
this is what I now have on my command button on...
I have managed to use the code
DoCmd.SendObject acSendReport, "rptName", acFormatPDF, "emailaddress.com", , , "subject", "Message "
however this is emailing all records from the report, I would like to only send the current record entered in the form. I'm thinking I need a where condition...
hi,
I have created a form that loads as add new record.
I also have a command button on my form that on click prints the current record entered as a report.
I would like the printed report to be sent in an email on the same command.
can anyone help with the code for this?
This is what I have...
Hi,
Firstly I am new to Access and also new to forums so this post my need more info to get what I want.
I have started creating a DB for my workplace the DB is to record measurements of products we have.
so the DB consist of product code, description, width, length, height, weight...