There are other methods:  Try this

Access
OutputTo Method [Access 2003 VBA Language Reference]
The OutputTo method carries out the OutputTo action in Visual Basic.

expression.OutputTo(ObjectType, ObjectName, OutputFormat, OutputFile,
AutoStart, TemplateFile, Encoding)

expression Required. An expression that returns a DoCmd object.

AcOutputObjectType
AcOutputObjectType can be one of these AcOutputObjectType constants.
acOutputDataAccessPage Not supported.
acOutputForm
acOutputFunction
acOutputModule
acOutputQuery
acOutputReport
acOutputServerView
acOutputStoredProcedure
acOutputTable

ObjectName  Optional Variant. 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.

AcFormat
AcFormat can be one of these AcFormat constants.
acFormatASP
acFormatDAP
acFormatHTML
acFormatIIS
acFormatRTF
acFormatSNP
acFormatTXT
acFormatXLS

OutputFile  Optional Variant. 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  Optional Variant. 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  Optional Variant. A string expression that's