Recent content by tomking505

Well, a miracle ocurred! I solved my own problem. I'm posting the code so that others that follow might find it. (That's how I stumbled on it, myself.) I needed to add a SelectObject to the code I posted above. That's the connection between the OpenReport and the OutputTo. This works...

>I think if you open the report as you are and then output, it will create a filtered PDF. I am grateful for your response, but the PDF is always the first client. What I have now is: DoCmd.OpenReport "MyReport", acViewPreview, , "[ClientID] =" & stJustOne, acHidden DoCmd.OutputTo...

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] =" &...

Holy Cow! I just posted that a few seconds ago! Thank you very much.. I pasted that in. Oh my god, it's working. I've been a programmer (not VBA) for decades. This simple two hour project has gone on two days now, and I'm embarrassed to say I just wiped away a tear. Thank you very, very...

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...