publish a series of archive reports each week

[gdervage]

I have a group of reports which I would like to publish weekly and keep a copy of each weeks reports. I am currently using the publish action to publish these reports to a folder. The problem the reports will be over written each week. What I would like to do is publish the report as I am now but append the current date as part of the report name.

Thanks
Guy Dervage

 

[MichaelRed]

Copy from HELP!!!

OutputTo Method


The OutputTo method carries out the OutputTo action in Visual Basic. For more information on how the action and its arguments work, see the action topic.

Syntax

DoCmd.OutputTo objecttype[, objectname][, outputformat][, outputfile][, autostart][, templatefile]

The OutputTo method has the following arguments.

Argument Description

objecttype One of the following intrinsic constants:
acOutputDataAccessPage
acOutputForm
acOutputModule
acOutputQuery
acOutputReport
acOutputServerView
acOutputStoredProcedure
acOutputTable
objectname A string expression that's the valid name of an object of the type selected by the objecttype argument. If you want to output the active object, specify the object's type for the objecttype argument and leave this argument blank.
If you run Visual Basic code containing the OutputTo method in a library database, Microsoft Access looks for the object with this name first in the library database, then in the current database.
outputformat One of the following intrinsic constants:
acFormatASP
acFormatDAP
acFormatHTML
acFormatIIS
acFormatRTF
acFormatSNP
acFormatTXT
acFormatXLS
If you leave this argument blank, Microsoft Access prompts you for the output format.
outputfile A string expression that's the full name, including the path, of the file you want to output the object to.
If you leave this argument blank, Microsoft Access prompts you for an output file name.
autostart Use True (–1) to start the appropriate Microsoft Windows–based application immediately, with the file specified by the outputfile argument loaded. Use False (0) if you don't want to start the application. This argument is ignored for Microsoft Internet Information Server (.htx, .idc) files and Microsoft ActiveX Server (*.asp) files.
If you leave this argument blank, the default (False) is assumed.
templatefile A string expression that's the full name, including the path, of the file you want to use as a template for an HTML, HTX, or ASP file.


Remarks

Modules can be output only in MS-DOS Text format, so if you specify acOutputModule for the objecttype argument, you must specify acFormatTXT for the outputformat argument. Microsoft Internet Information Server and Microsoft ActiveX Server formats are available only for tables, queries, and forms, so if you specify acFormatIIS or acFormatASP for the outputformat argument, you must specify acOutputTable, acOutputQuery, or acOutputForm for the objecttype argument.

You can leave an optional argument blank in the middle of the syntax, but you must include the argument's comma. If you leave a trailing argument blank, don't use a comma following the last argument you specify.
MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[gdervage]

Mike,

I won't have a chance to try this for the next day or two.
I will let you know if I have any trouble. Thank you for answering so quickly.

Guy Dervage