View Full Version : Help on saving a snapshotreport til file automatically when a new record is posted.


selvsagt
07-14-2006, 06:43 AM
How can I save a new record to file in snapshot format when the post is entered?

Preferably the user enters a new post with a data access page (html), that automatically saves a finished report to file.

The code for saving the document is here, but how can I "launch" this code to a button in my data access page?

I cant seem to find a "run" command ord "Enter" command.
Please help.

Here's the code:


Dim stDocName As String

stDocName = "rptMain"
DoCmd.OutputTo acOutputReport, stDocName, acFormatSNP, "\\rsa\rptMain.snp", False

Should I save the code as a module, and then launch the module with the button?

Please help, I have no idea solving this.