How to Export Report to Excel.

[nebula53]

Hi,

1 - I created search criteria based in one input ( contract status “ Combo box”)
I need to add to it another criteria (Vendor Number “ text Box” ) ( the number will be entered manually )

This is the Code in the Search button.

Dim strCriteria As String
Dim strReportName As String
  
strCriteria = "[Contract Status]='" & Me![Contract Status] & "'"
strReportName = "PMCONTRACTS"
  
If [Contract Status] = "Select" Then
    DoCmd.OpenReport strReportName, acViewReport
Else
    DoCmd.OpenReport strReportName, acViewReport, , strCriteria
End If

' Reset Form
[Contract Status] = "Select"

3- in the Report how can I have ascending numbers next to the rows. (1,2,3,……)

Please find the attached .




PS : Regarding number (2) question how to Export report to Excel.

Thank you I found the answer in this link http://bytes.com/topic/access/answer...a-output-excel