By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,098 Members | 2,007 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,098 IT Pros & Developers. It's quick & easy.

How to Export Report to Excel.

P: 32
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.

Expand|Select|Wrap|Line Numbers
  1. Dim strCriteria As String
  2. Dim strReportName As String
  3.  
  4. strCriteria = "[Contract Status]='" & Me![Contract Status] & "'"
  5. strReportName = "PMCONTRACTS"
  6.  
  7. If [Contract Status] = "Select" Then
  8.     DoCmd.OpenReport strReportName, acViewReport
  9. Else
  10.     DoCmd.OpenReport strReportName, acViewReport, , strCriteria
  11. End If
  12.  
  13. ' Reset Form
  14. [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
Attached Files
File Type: zip TEST F.zip (39.6 KB, 52 views)
Dec 13 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.