Using list Box to sort data in the report (1 Viewer)
- Thread starter Finance
- Start date
Hi!
thanks for replying!
yes, no wonder i cant seem to sort it through the report.
Could you give me an example of how I can use it through a form?
Problem:
these are the details on my form.
Complexity 1:
I want my report to show that the office action record in the field: Nature of Expenses is ($3000*1=)$3000 because the complexity is 1.
can this be done?
thanks for replying!
yes, no wonder i cant seem to sort it through the report.
Could you give me an example of how I can use it through a form?
Problem:
these are the details on my form.
Complexity 1:
I want my report to show that the office action record in the field: Nature of Expenses is ($3000*1=)$3000 because the complexity is 1.
can this be done?
- Local time
- Today, 15:00
- Joined
- Jan 23, 2006
- Messages
- 15,379
Hi,
There is an error with the filtering on the database. I have put the code in using the combo box to filter out the years but there is an error in the filtering VBA code, I am attaching my database.
Please help.
There is an error with the filtering on the database. I have put the code in using the combo box to filter out the years but there is an error in the filtering VBA code, I am attaching my database.
Please help.
The problem is because you convert the criteria to a string value, use the below code.
Code:
Private Sub CommandAPplyFilter_Click()
Dim strYears As String
Dim strFilter As String
' Check that the report is open
If SysCmd(acSysCmdGetObjectState, acReport, "Patent_Cost_Forecast") <> acObjStateOpen Then
MsgBox "You must open the report first."
Exit Sub
End If
' Build criteria string for Office field
If Not IsNull(Me.Combo8.Value) Then
strYears = "=" & Me.Combo8.Value & ""
End If
' Combine criteria strings into a WHERE clause for the filter
strFilter = "[Years] " & strYears
' Apply the filter and switch it on
With Reports![Patent_Cost_Forecast]
.Filter = strFilter
.FilterOn = True
End With
End SubIt is for integer values.
