Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Report to HTML in One Single Page

Status
Not open for further replies.

Fattire

Technical User
Nov 30, 2006
127
US
I'm exporting the data I have in a report to the desktop of the user and in this particular case its 8 pages long. When I export it, it comes out in 9 separate html files...

How do I prevent that - so it comes out in one long HTML file.

Code:
Private Sub cmd_ExportOpen_Click()
    
    Dim varCustNumber As String
    
    varCustNumber = Me.txt_CustomerNumber
    
    varWinUserName = WinUserName()
    varDate = Format(Format(Date, "DDMMMYYYY"), ">")
    varFileName = "Open Invoices" & " - " & varCustNumber & ".html"
    varPathName = "C:\Documents and Settings\" & varWinUserName & "\Desktop\" & varFileName
    
    DoCmd.OutputTo acOutputReport, "Open Invoices HTML", acFormatHTML, varPathName

End Sub

Thanks in advance
 
You would have to build your own HTML.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top