OUTPUT TO HTML format ONE PAGE needed in Access Report

[Tamrak]

Hello,

I could not locate the answer, which might be a simple way.

I created a macro to Export the Report into an HTML format. The problem that I have is, Access created several HTML files. I have over 20 files because I have more than 20 pages. The user does not want any other format, except HTML. In Excel spreadsheet, the output comes out only one sheet. (The user will not accept Excel output.)

I checked the setting (page set-up) and could not find anything that I could do differently, aside from portrait and landscape. They have some options on legal, letter.. etc.

Is there anyway to have the output come out as one HTML page with no Previous, Next, Last, First tags? The user does not mind scrolling down the page.

All advices are very much appreciated. Thanks.

 

[dRahme]

Hello, I do not know how to work around that using a report but if you were to use a form formatted to print as a report...

Private Sub Command1_Click()
On Error GoTo Err_Command1_Click

Dim stDocName As String
Dim MyForm As Form

stDocName = "frmPrintTest"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.OutputTo acOutputForm, stDocName, acFormatHTML
DoCmd.SelectObject acForm, MyForm.Name, False

Exit_Command1_Click:
Exit Sub

Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click

End Sub

Hope that helps.