By using our site, you acknowledge that you have read and understand our Cookie Policy , Privacy Policy , and our Terms of Service. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. The following code works on my Access , but brings a compile error for users with Access This opens on my Access yet to test Access but only in the Excel 5. Is there a way I can open this in the normal

Author:Yozshuk Yogis
Language:English (Spanish)
Published (Last):17 July 2014
PDF File Size:17.78 Mb
ePub File Size:19.56 Mb
Price:Free* [*Free Regsitration Required]

An AcOutputObjectType constant indicating the type of object to export. The name of the object to export. If omitted, Access exports the active object of type ObjectType. An AcFormat constant indicating the export format. A Boolean that determines whether the application that handles OutputFile should open and load the file. Its default value is False. XML does not have an intrinsic constant in Access If the OutputFormat and OutputFile arguments are omitted, Access prompts for the export file type and export filename, respectively.

If AutoStart is True, the application launched to handle the exported file is defined by the system registry. Generally, the exported files appear to be much more robust than in some previous versions of Access. I was unable to get IIS. Except for an ASP page, which uses ADO to retrieve live data from the database, all exported files contain static data; they provide a snapshot of the data at a given point in time. Previous page. Table of content. Next page. Authors: Michael Vine.

Qshell for iSeries. MySQL Cookbook. Extending and Embedding PHP. Microsoft Visual Basic. If you may any questions please contact us: flylib qtcs. Privacy policy. This website uses cookies. Click here to find out more. Accept cookies.

EO 13603 PDF

Subscribe to RSS

OutputTo Method. Now, previously pre Office , the basic format to export a query to Excel format was simply:. So your code would thus become:. Nothing could be easier!


How to Output a dynamically filtered Access report to PDF

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

Related Articles