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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
command button for save 1
Save a record in Snap shot format 1
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Error on simple expression in footer 2
Saving Sample Northwind Files 2
Trouble with command button 3
adding records to a sub form 2

Back
Top