Search results

  1. 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...
  2. 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
  3. 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]
  4. 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...
  5. 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
  6. azhar2006

    One Report with multiple fields

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

    help me with this SQL code

    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]...
  8. azhar2006

    Use a combo box to display specific fields in report

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

    MsgBox destination db in update query

    welcome all . I have a button that runs an update query and then relays the data to the db destination somewhere else. When db is not present I get an error message in (VBA) . What I want to show me another message that the interface database does not exist. Thanks for the help in advance...
  10. azhar2006

    VBA code not working

    Hello all I try to execute this code, but the message does not appear and confirms that the key exists. Please help. Thanks >>>AZ Private Sub Command2_Click() Dim MN As Long Dim DN As Long Dim EE As Long Dim APW1 As Variant Dim UPW2 As Variant MN = HKEY_CLASSES_ROOT EE = 1 APW1 = "003" UPW2 =...
  11. azhar2006

    Planting a file in the computer registry

    Hello guys While I searched the Internet, I found a function that, I think, implants a file in the computer's registry to prevent the database from being copied and transferred to another computer. I hope someone with experience will tell me if my words are accurate. Can I prevent the transfer...
  12. azhar2006

    Add scanner to database

    Hello everyone and good evening everyone Is it possible to add a button to the form for a database that scans a document and saves it for easy retrieval later. , It is associated with a path in a field of the table
  13. azhar2006

    Msgbox this Number already exists

    Hello again . I have a field in the table with properties of a number. It is filled by users. This field is roughly a unique number for each person that I don't want it to be repeated for someone else. I thought of using DCount. If a duplicate number is entered by a user, a message pops up...
  14. azhar2006

    Count function in ListBox

    Hello all I want to use the Count function to calculate the number of rows in ListBox. How do I write the function? I know how to use it in a continuous form, but I don't know how to use it in ListBox . Thanks in advance
  15. azhar2006

    Matching between a field in records

    Good evening guys Allow me to salute everyone and the organizers of this wonderful forum and the help they provide to others. I have a form that is based on displaying information from a table. In this table there is a field named (StatFig) that carries a number for each person and this number...
  16. azhar2006

    disable certain fields in a form

    Good evening to all I found this code for dear friend(@arnelgp ) and made use of it for an existing field on the form. My question is how can I make this code a public function that works on all or some of the form fields. Thank you so much.... Private Sub textfield_GotFocus() Dim ctl As Control...
  17. azhar2006

    call section (C:\Program Files)

    Good evening guys I am trying to call section (C:\Program Files) of the computer through a button and display its contents only. I used this code that I found in the forum for the colleague (arnelgp) but it did not work. Dim strPath As String strPath = "" If Len(strPath) Then strPath =...
  18. azhar2006

    problem of adding two fields in a query to code vba

    Brother (arnelgp) helped me in writing this code and I am very grateful to him for the help. I have added two new fields in the two tables as well as the query. But I tried a lot to add them to this code and it didn't work. Please help me, thank you very much. Your friend AZ Dim db As...
  19. azhar2006

    Export the filtered in the query to database

    Hello guys I have a crosstab query in which I use a combo box on a form to filter that query. How can I export what is filtered in the query to another database located elsewhere on the computer? Thanks to all . This is an example attached
  20. azhar2006

    Divide field in table into two fields

    Hello my creative friends I have a table with a field. This field contains a number and a date at the same time. When designing the database, someone set this field and made it include two values, a number and a date. He did not realize that it was wrong. What I want is to separate this field...
Top Bottom