Search results

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...

thank you ,dear CarlettoFed . amazing(y)

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

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

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

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]

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...

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...

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

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

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

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...

Thank you plog . And if one button based on a certain value in a field?

Hello my friends:) I have a report with six fields, and I have a form with two buttons to print the same report. What I want to do is have one of the buttons on the form display the full report with all its fields, and the second button, when clicked, will show the same report, but with only...

Private Sub cmdExecute_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strStatFig As String Dim strRtba As String Dim strNumberUpgradeAfter As String Dim strDateUpgradeAfter As String Dim strSQL As String Set db = CurrentDb Set rs = db.OpenRecordset("qryNamesWithNew"...

strSQL = "UPDATE tblmastr SET tblmastr.Rtba = '" & strRtba & "'.....tblmastr.NumberUpgradeAfter and DateUpgradeAfter

Hello my friends Can i get your help with this code. I want to add (NumberUpgradeAfter) and (DateUpgradeAfter) to (strSQL) clause While rs.EOF = False strStatFig = rs![StatFig] strRtba = rs![Rtba] strNumberUpgradeAfter = rs![NumberUpgradeAfter]...

Thank you very much, my dear colleagues. I have added this code in the query. But I face a problem when the fields for some records are empty. IIf(IsNull([Forms]![frmcomSearch]![cmboFirstRtba]);[Rtba];[Forms]![frmcomSearch]![cmboFirstRtba])

Hello, Hello guys . I hope to find someone to help me. I have a report in the database based on a query and through a button on the form the report appears to me with all its fields according to the query. What I want is to hide and show some columns in the report. for example. I need a report...

Thanks theDBguy . Will it appear as text boxes or as a table?