Search results

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:

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

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:

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

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

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

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

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

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

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

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

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

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 🌻

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

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 :) 🌷

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

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.

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

Thank you very much my dear friend