Adding a Save to file button

  • Thread starter Thread starter Kyle
  • Start date Start date
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.
 
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"
 
Back
Top