Hi Ryan, I have looked at your code. Here is a line of mine that works and outputs a pdf:
DoCmd.OutputTo acOutputReport, "ForExportR", acFormatPDF, TempVars!mylocation & "Parts.pdf"  Your code has several variables. I would test your code by replacing  strLettername with the actual path and see what it looks like.  I am assuming that you checked to make sure the drive is available to you. HTH  John

Yes, Access has access to  the drive. So, I know that’s not the issue. I’ve replaced all the variables with the actual paths and I get the same results. A pop-up window shows that the Access is Outputting the report to the proper location, and then it stops. I look in the directory and Access creates the Folder but doesn’t process or save  the PDF. I’ve changed the default printer to the report to “Microsoft to PDF” and nothing happens. It just stopped working. It’s weird, because it was working before I placed this automated in the On Load, On Open, or  On Timer.

My guess is that your data is not loaded at this point so your report is not going to have the data available. Try running the report by itself and see if it runs. Run your routine from a button n the form (after the data has loaded)  john

Before you try running it in an event, see if you can get it to run from a button like John said.

I've isolated the OutputTo to a button with just one line of code and it still doesn't work. Is there a workaround outside of using the OutputTo command?

Hi Ryan, Does the report run by itself?  John

When you say it doesn't work, can you be a little more specific? What's happening? Does nothing happen? Also, make sure that is a valid folder and that you have rights to write to it. I would suggest putting it in your database folder directly to start off with.

Yes. I can open the report up fine when I directly run the report.

Hi Ryan, I tested a few thing in your code but cannot recreate all that you have for I don't have the entire database, but I am quite sure your problem is with the variables that you have. You need to be sure that strOrders is giving you what you think it is, stDirectoryPath is giving you what you think it is and tempvars is giving you what you think it is. Simplify your code with hard coded paths first and get it to work. The problem is in the variable (maybe a backslash or space in the variable) After it is working (it does work and outputs a PDF but not with your variables)  John

I got it to work! The report itself was the problem. I have the report creating barcodes and printing them out. If an item doesn’t have a barcode the report errors but doesn’t inform me. It just stopped processing. I added 1 line before the barcode prints:

If WebPayment <> “Pay at Register” then Exit Sub.

It saved the file just fine! Thanks John for your help! I wouldn’t have thought to check the report since all the other reports I saved had barcodes!