title: MS Access: Command button to export a report to a CSV file
body: <p>I was wondering if this was possible.  I have my main form with a bunch of tables on it, and then I have a report.  Standard stuff there.  The report is named <code>Report1</code>.  What I was wondering, is there a way I can put a command button on my main form, that when pressed, will export <code>Report1</code> onto my desktop (or wherever I specify) in a CSV format?  I would like to do this in VBA if possible.  I'm not sure if I could make a macro format into CSV, but I am pretty open to any suggestions.  Thank you</p>