Recent content by azhar2006

  1. azhar2006

    Search through textbox

    thank you MarkK dear It works fine, but why did you put the event in on Private Sub txtSearch_Change() ? Private Sub txtSearch_Change() With qdfSearch .Parameters(0) = "*" & Me.txtSearch.Text & "*" Set Me.Recordset = .OpenRecordset End With End Sub
  2. azhar2006

    Search through textbox

    This is database file.
  3. azhar2006

    Search through textbox

    Thank you for replying Nothing happens. Yes, it is a query based on a table
  4. azhar2006

    Search through textbox

    Hello guys . You have created a form based on a query. And put a text box in it for the purpose of conducting a search in the query records. I used this code that my dear brother (arnelgp) helped me write, but the code does not work. I don't know where the problem is Thank you very much Private...
  5. azhar2006

    Convert code VBA to expression in query

    thank you ,dear CarlettoFed . amazing(y)
  6. azhar2006

    Convert code VBA to expression in query

    IIf(IsNull([Forms]![frmMastr]![txtsucc]);[Success];[Forms]![frmMastr]![txtsucc])
  7. azhar2006

    Convert code VBA to expression in query

    Hello friends again I need help converting this code from VBA to an expression in a query. I've tried hard and failed to turn it into an expression. If Not IsNull(Me.txtsucc) Then strWhere = strWhere & "([Success] = """ & Me.txtsucc & """) AND " End If Thank you very much
  8. azhar2006

    Error in the query statement.

    Thank you very much for replying. I'm trying to do filter
  9. azhar2006

    Error in the query statement.

    Hi guys I have created a query and I used this expression in one of the query fields, but I encounter an error in the sentence. Can you help me fix the error Thanks to all . [Forms]![frmRptDeprmnt]![Combo];[Department];[Forms]![frmRptDeprmnt]![Combo]
  10. azhar2006

    Preview report based on filter query

    Thank you dear Ranman256 did not work for me. Just to inform you something that I use in the textbox filter based on this code. Private Sub TypeDown(strSearch As String) On Error Resume Next Dim StrSQL As String If strSearch = "" Then StrSQL = "QurMastr" Else...
  11. azhar2006

    Preview report based on filter query

    Hello all I have a report based on a query, and in this query, I make a filter for the information included in it through a form. I have put a print button on the form that previews the report based on the filtering process through a text box. But when the report appears, all the data, not the...
  12. azhar2006

    Expression Count

    Thank you very much arnelgp You are amazing. It worked out regularly
  13. azhar2006

    Expression Count

    Hello all I have a main form and a subform inside. I want to execute this expression (=Count([fullname])) on the subform and I put it on the main form. Thanks to all
  14. azhar2006

    One Report with multiple fields

    thank you sir And I did what you said. But I know they will come back to me in the future for some changes:)
  15. azhar2006

    One Report with multiple fields

    Thank you very much . I created another report and put a button to open it. The user can choose what report he wants by clicking on the first or second button. I was thinking of using the function (if) based on a specific value in the table, for example the country. Whereas, if the country is...
Top Bottom