Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

auto export html

Posted on 2011-03-01
2
Medium Priority
?
484 Views
Last Modified: 2012-05-11
Is there a way to automatically export a report with Html type. i have stored a RunSavedImportExport that when i run it it asks me for Html Output Options.

in vb i have created the command Docmd.RunSavedImportExport "Export-Report1" but it asks me for HTML Output Options. Is there a way to bypass that? or is there any other way of exporting my report to a html format?
0
Comment
Question by:repco
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 26

Accepted Solution

by:
Nick67 earned 2000 total points
ID: 35011635
The options exist in the OutputTo command to specify all that.
The code below sends rptMyReport in html to c:\temp\test.html

Private Sub ExportMyReportToHTML()
Dim stdocname As String
Dim FormatValue As String

FormatValue = acFormatHTML
stdocname = "rptMyReport"

DoCmd.OutputTo acOutputReport, stdocname, FormatValue, "c:\temp\test.html", True
End Sub

Open in new window

0
 

Author Closing Comment

by:repco
ID: 35012550
thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question