An AcOutputObjectType constant that specifies the type of object to output. If you run Visual Basic code containing the OutputTo method in a library database, Microsoft Office Access searches for the object with this name first in the library database, and then in the current database. An AcFormat constant that specifies the output format. Si vous oubliez cet argument, Access vous demande le format de sortie. If you omit this argument, Access prompts you for the output format. If you leave this argument blank, Access prompts you for an output file name.
|Published (Last):||4 May 2005|
|PDF File Size:||16.13 Mb|
|ePub File Size:||11.56 Mb|
|Price:||Free* [*Free Regsitration Required]|
Less You can use the ExportWithFormatting action to output the data in the specified Access database object a datasheet, form, report, or module to several output formats.
The arguments are still the same for this macro action. Settings The ExportWithFormatting action has the following arguments. Action argument Description Object Type The type of object containing the data to output. If you want to output the active object, select its type with this argument, but leave the Object Name argument blank. This is a required argument. The default is Table. Object Name The name of the object containing the data to output. The Object Name box shows all objects in the database of the type selected by the Object Type argument.
If you run a macro containing the ExportWithFormatting action in a library database, Access first looks for the object with this name in the library database, and then in the current database.
Output Format The type of format you want to use to output the data. If you leave this argument blank, Access prompts you for the output format. Output File The file to which you want to output the data, including the full path. You can include the standard file name extension for the output format you select with the Output Format argument, but it is not required. If you leave the Output File argument blank, Access prompts you for an output file name.
Auto Start Specifies whether you want the appropriate software to start immediately after the ExportWithFormatting action runs, with the file specified by the Output File argument opened. If you leave this argument blank, Access outputs the data by using the Windows default encoding for text files and the default system encoding for HTML files. Output Quality Select Print to optimize the output for printing, or Screen to optimize the output for display on a screen.
Remarks The Access data is output in the selected format and can be read by any program that uses the same format. For example, you can output an Access report with its formatting to a Rich Text Format document and then open the document in Microsoft Word. You can use the Template File argument to specify a file to be used as a template for the. The following rules apply when you use the ExportWithFormatting macro action to output a database object to any of the output formats: You can output data in table, query, and form datasheets.
In the output file, all fields in the datasheet appear as they do in Access, with the exception of fields containing OLE objects. The columns for OLE object fields are included in the output file, but the fields are blank. For a text box bound to a Hyperlink field, the output file displays the hyperlink for all output formats with the exception of MS-DOS text in this case, the hyperlink is displayed as normal text.
When you output a datasheet or form in HTML format, one. When you output a report in HTML format, one.
The result of running the ExportWithFormatting macro action is similar to clicking one of the options in the Export group on the External Data tab. The action arguments correspond to the settings in the Export dialog box. Expand your Office skills.
DoCmd.OutputTo method (Access)
Subscribe to RSS
DoCmd.OutputTo in xlsx (Excel 2007+) Format