DoCmd.OutputTo results are blank (1 Viewer)

[BamaColtsFan]

Okay, so there I was...

No really, I'm trying to send the content of a form to an external file using VBA. I'm pretty sure that the OutPutTo method is the proper way to do it but I can't seem to get it right. The code below will execute and the file is properly formatted. The only problem is that it is blank. I've tried several different formats (Excel, RTF, Text...) and I get the same with all of them. It appears to execute fine but the results file is blank. Any idea what I'm doing wrong here? Interestingly, I can open the form and export it directly to a PDF file and it looks great.

DoCmd.OutputTo acOutputForm, "frmStatusByCatFinal", acFormatXLS, strPath, True

As always, I appreciate the help you guys give!

THNX

 

[madEG]

Are you asking how to send a print screen of a form to an output file/image? Not merely the data, but a picture of the form itself, and whatever data may be in the various objects/fields on the form?

http://stackoverflow.com/questions/2456998/is-there-a-way-to-take-a-screenshot-in-ms-access-with-vba

 

[BamaColtsFan]

Yes, that is what I am trying to do. The nature of the data is that it will remain static until the next update. There is only one set of records (from multiple queries) that will be displayed on this form at any given time. My intent is to send the image to a file then e-mail that file for reporting purposes...