?
Solved

auto export html

Posted on 2011-03-01
2
Medium Priority
?
486 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
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses
Course of the Month13 days, 22 hours left to enroll

809 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