Help on saving a snapshotreport til file automatically when a new record is posted.

selvsagt

Registered User.
Local time
Today, 02:26
Joined
Jun 29, 2006
Messages
99
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.
 

Users who are viewing this thread

Back
Top Bottom