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.
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.