Recent content by Guidon Mendoza

  1. G

    Dropbox changed value does not appear in its textbox

    This behavior is not related to any DB, but to the Key_Down event. After executing GetKey(), InputKey has the type of key strocked (if it's a command, text, special char, function key, etc.), and in KeyCode is the usable (ASCII) code of the key. Another detail is that when I press again...
  2. G

    Dropbox changed value does not appear in its textbox

    It did not work, but thanks for that anyways!
  3. G

    Dropbox changed value does not appear in its textbox

    Hi, everyone! I hope that someone of good heart can help me solve this. I developed a platform for a HR company. On it, I give the user the option to add skills to a candidate. And to do that, I have a ComboBox control. Since I need to take actions depending on the keyboard (Return, Esc, Tab...
  4. G

    Solved Problem in ADO, with .AddNew to a remote DB

    And thanks to you too, arnelgp!
  5. G

    Solved Problem in ADO, with .AddNew to a remote DB

    Thanks, Minty! That was fast!
  6. G

    Solved Problem in ADO, with .AddNew to a remote DB

    I just found the answer on a MySQL document. Here the quote: Multiple-Step Operation Error Using the AppendChunk() or GetChunk() ADO methods, the Multiple-step operation generated errors. Check each status value error is returned. The GetChunk() and AppendChunk()...
  7. G

    Solved Problem in ADO, with .AddNew to a remote DB

    Hi, everyone! I have a project to share information for a work group over the Internet. To do so, I created a front-end platform in Access 2016 and remotely connected it to a MySQL DB. The connection seams to work fine, since I'm able to read and make updates using the connection. I've been...
  8. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    At the end, this is the solution I was looking for! Thanks a lot!!!
  9. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Actually, that's what I wanted to do, but it did not work. This is how I started the question: "I have an MS Access 2016 platform linked to a MySQL database on a server somewhere. My platform is in 32-bit. I implemented Deletions, Creations and both work fine. But when I tried to Update...
  10. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Actually, I'm not connecting to the remote DB until I get the Insert done, but it's never done, because of the 3065 error. As background, I need the Recordset in the beginning of the code to create the INSERT query: I receive the Object, and create the strSQL to execute. strSQL = "USE...
  11. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Should I start a new thread? And actually is far faster with SQL, thanks!!
  12. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    No, I'm moving forward, using your help. Actually I was able to create a UPDATE query and make it work with an abstract object. Thanks!! Now I'm stuck with an Error Code 3065. The code I'm using is this: Function AddRec(Tbl As String, NewRec As Object, KeyId As String) As Long Dim DB As...
  13. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Thanks to all of you. Isladog, is that correct for every recordset type? And if so, then the database is locked through out the whole process? Pat, I did refresh it. Arnelgp, I'll try this option also. Thanks. Thanks again. G
  14. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    I did alter the table manually and it works fine. I modified the tables for everyone to have a PK/Unique field. Even then, it did not work...
  15. G

    Solved 3157: ODBC -- update on a linked table '???' failed

    Thanks a lot for the advise! I'll implement it as far as I can. The reason I wanted to use Recordsets is that the logic for constructing the SQL statements is complex in several parts of the program (and results in not very elegant code...), and the code is hard to abstract. On the other...
Top Bottom