I asked a similar question a few days ago and received this reply from CosmoKramer:
In a new module, add a function similar to this example of mine, of course adapting it to your situation:
Function Xferdoc_MonthStat()
Dim strFileName As String
strFileName = "c:\SMH Monthly Statistics...
Thanks to CosmoKramer. His reply to my question was right on. After trying the code I had to make a modification to one of the fields I was trying to use in the filename however. One of the fields was a date field. I had to chance the backslashes in between the day, month and year to dashes...
I have a report based on a query of an open form. The query selects the data for the report based on field information gleaned from the open form. I then output the report in html format to a designated directory on the network.
The user has to type in a file name to save the report to.
I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.