Adding a Save to file button

K

Kyle

The Order form of the Northwind sample database from MS
Access, is there a way to add a Save button for user to
click on and save the order invoice into a snapshot file to
a directory of C:\OrderInvoice\.
If anyone have a sample code for this save button handy and
don't mind to post in this group would be appreciated.
 
S

Steve Schapel

Kyle

Change the Record Source of the Invoice report to Invoices Filter
instead of Invoices.

Then your code will be like...
DoCmd.OutputTo acOutputReport, "Invoice", "SnapshotFormat(*.snp)",
"C:\YourFolder\YourFile.snp"
 
Top