Search results

  1. A

    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 =...
  2. A

    Export the filtered in the query to database

    Very good my friend, look at the attachment, and if there are some modifications you can make, I hope for your generosity, my friend . Can I change the access messages to messages that I choose?
  3. A

    Export the filtered in the query to database

    Thank you very much with all my heart my dear friend @theDBguy
  4. A

    problem of adding two fields in a query to code vba

    I'm going to write this line On Error Resume Nextagain hahahah :ROFLMAO:, thank you very much my friends (June7) and (theDBguy ) and (arnelgp)
  5. A

    problem of adding two fields in a query to code vba

    It has already done the update but it clears me this error message
  6. A

    problem of adding two fields in a query to code vba

    Thank you dear (theDBguy) Please see this attachment
  7. A

    problem of adding two fields in a query to code vba

    Thank you very much for the help. This is a simulation database only, not the original. I use the table names explicitly in it. I got this message about the date field.
  8. A

    problem of adding two fields in a query to code vba

    Dim db As DAO.Database Dim rs As DAO.Recordset Dim strUnifiedNumber As Long Dim strSpecialization As Variant Dim strSN As Variant Dim DateSn As Variant Dim intCounter As Integer Dim strSQL As String Set db = CurrentDb Set rs = db.OpenRecordset("qryUnifiedNumber", dbOpenSnapshot) 'Make sure...
  9. A

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

    Divide field in table into two fields

    https://www.access-programmers.co.uk/forums/threads/export-the-filtered-in-the-query-to-database.320546/
  11. A

    Divide field in table into two fields

    good morning . Thank you very much my friend (theDBguy) The expression worked out great. With some errors and the reason for entering data into the table, they can be fixed manually. Thanks are also due to all.
  12. A

    Export the filtered in the query to database

    Aha, thank you very much for this question. Thank you for replying to my topic. What I want to do is to create multiple and separate databases (Access file) for each specific entity.
  13. A

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

    Divide field in table into two fields

    SELECT tbljasim.NumDateOrder, Val([NumDateOrder]) AS Expr1 FROM tbljasim; How will the date come out with another column?
  15. A

    Divide field in table into two fields

    It doesn't matter who builds the table again by creating a query. The important thing is to separate that information in this field from each other. Then I can go ahead. The fact that this data in this field exceeds more than ten thousand records
  16. A

    Divide field in table into two fields

    OK dear (theDBguy) in the table design are text . On display as shown in the attached photo
  17. A

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

    Migrate a table in the database to another database

    thank you my dear (theDBguy)
View older results
Back
Top Bottom