Search results

Thanks to Bob, my program works perfectly. Now, rather than sending the reports to the printer, I want to save them as PDFs. I'm generating hundreds of these, so I need to specify the filename of the PDF. I need to turn this: DoCmd.OpenReport "myReport", acViewPreview, , "[CclientID] =" &...

I know just enough to be dangerous, but clearly not enough to be useful. My WHERE clause in the following DoCmd.OpenReport statement doesn't work Option Compare Database Public Function Closer2() Dim MyDB As DAO.Database Dim rstParseNames As DAO.Recordset Dim stJustOne Set MyDB = CurrentDb...