Search results

  1. A

    Migrate a table in the database to another database

    Your words are always accurate. We are beginners. We go to turn off the warning messages haha and we know there's a lot of trouble behind it, a bit like that of an old car.:giggle:
  2. A

    Migrate a table in the database to another database

    Do I delete the ID number field from the query? I sent you a sentence SQL have you seen it?
  3. A

    Migrate a table in the database to another database

    Thank you my dear friend DBG you saved me. It was the (On Error Resume Next) line that prevented me from knowing where the problem lay. Thanks a lot for the help. Your code worked well.:p:p:giggle::giggle:
  4. A

    Migrate a table in the database to another database

    The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. (Error 3022) You tried to duplicate a value in a field that is the underlying table's primary key or an index that does not allow duplicates. The...
  5. A

    Migrate a table in the database to another database

    keeps giving zero On Error Resume Next DoCmd.Hourglass True DoCmd.SetWarnings False With CurrentDb .Execute "QueryAppend", dbFailOnError MsgBox "Appended " & .RecordsAffected & " records.", vbInformation, "Info" End With DoCmd.Hourglass False...
  6. A

    Migrate a table in the database to another database

    Show me this message. After pressing yes, another message appears. But when removing the password from the database, this message appeared
  7. A

    Migrate a table in the database to another database

    Thank you dear DBG ..yes, I have now tried it and it shows me the number of records is zero
  8. A

    Migrate a table in the database to another database

    Hello guys . I am migrating a table in the database to another database in partition(D) through an append query. And use a button to run this query based on the event below on click. What I want is when I run the append query through the button, a message appears saying that I have appended or...
  9. A

    User defined type not defined in Access2007

    Oooooh. Thank you very much my friend (arnelgp) you always help me(y):)
  10. A

    User defined type not defined in Access2007

    Yes terminator 3. But I want the text to appear in the form of stars because I use it for a password. Last week dear (theDBguy) helped me with that
  11. A

    User defined type not defined in Access2007

    Use this code which is a code written by Daniel Clan. It converts letters and numbers to stars in (InputBox) but I'm facing a problem which is (User-defined type not defined) . Please help with that. Public Function InputBoxDK(Prompt As String, Optional Title As String, _...
  12. A

    Combo Box woes

    I thank you very much for two examples. Greetings, I was happy to download them
  13. A

    Deactivate the print report button. for a specific report

    Thank you my friend (DBG) This is all that is needed, you are really great. Greetings to you who helped me and to all the people in this wonderful forum. Thanks again 🌻
  14. A

    Deactivate the print report button. for a specific report

    Activating the button or deactivating the button may be for one person in the table or two people out of a total of hundreds of them. This person cannot print his report because there is some missing information in his record. But other people who have all the information do not need to close...
  15. A

    Deactivate the print report button. for a specific report

    Thank you (theDBguy) This is what I want. Thank you, my friend, but there is one point, which is when you move to the other person, the print button remains inactive. And I want when I move to the other person, the Option8 goes back to being inactive :) 🌷
  16. A

    Deactivate the print report button. for a specific report

    Here is an example, my friend. When we deactivate the print button, no one can return it except through a password
  17. A

    Deactivate the print report button. for a specific report

    Thank you very much, my friend. Actually, I chose the report based on the ID number, this thing I did before. But what I want is that through the toggle button close the print button. The print button cannot be activated again without a password. So this employee's report is not printed.
  18. A

    Deactivate the print report button. for a specific report

    Hello guys . I have a database that contains reports belonging to people, some of these people have a lack of their information in the table. Everyone has their own report. How can I make the print report button deactivated to print the report for some of them and with the option of the database...
  19. A

    query calculates the age

    Thank you very much my dear friend
Back
Top Bottom