Recent content by ZeidHaddad

  1. Z

    Update code

    Hey so i deleted the whole thing with the else and this is the code now Private Sub speichern_Click() On Error GoTo speichern_Click_Err On Error Resume Next Dim MaxID As Variant Dim StrSQL As String If Me.Vertragsnummer = DLookup("[Vertragsnummer]", "Dokumentation"...
  2. Z

    Update code

    so now i'm treating Anruf_2 and Anruf_3 as a text
  3. Z

    Update code

    good question. when i changed them into date and time in every table they caused a lot of problem and stopped saving in the target table we had to change back to text.
  4. Z

    Update code

    Good morning everyone! i have a problem regarding an update code, the code used to work just fine before i added a second update which is ( StrSQL = "UPDATE Dokumentation SET Name) inside where the first one stopped working but the second is working. so Update "Table=Dokumentation" is working...
  5. Z

    Combining 2 codes under one button

    Good luck for you as well have a nice day
  6. Z

    Combining 2 codes under one button

    hello everyone :D any idea how to combine those 2 codes under 1 button Private Sub Befehl396_Click() Dim rs As DAO.Recordset Dim StrSQL As String On Error GoTo cmdRefresh_Click_Err If Me.Vertragsnummer <> "" Then 'commentary StrSQL = "SELECT * FROM...
  7. Z

    filling a form from a specific table

    Okay i see! thank a lot adam i'll post another Thread asking how to combine both under 1 button only
  8. Z

    filling a form from a specific table

    Oh Btw Is It possible to combine both codes under one button ?
  9. Z

    filling a form from a specific table

    Hey it's because I'm using more than one table to add data into the Form :D it's Solved now but thanks for Your Reply
  10. Z

    filling a form from a specific table

    Thank You adam it's working now! enjoy Your shower
  11. Z

    filling a form from a specific table

    Hello, thanks for your reply. the thing is all data types are the same for sure! i don't think it's necessary to do the "set = Nothing" but thank you for the advice i will use it. no line is being highlighted however after a test i did i think the problem is coming from here StrSQL = "SELECT *...
  12. Z

    filling a form from a specific table

    filling a form from a specific table (Solved) Hello Everyone! so i'm trying to pull data from a table and then update it in my form, not really sure if this is the best explanation :banghead: so to explain it better Code: Private Sub Befehl396_Click() Dim rs As DAO.Recordset Dim...
  13. Z

    Update Code

    Okay now it's Finally working. Thank You all for the Help!
  14. Z

    Update Code

    did this, i got the correct thing inside the Vba but still inside the table it's Not Updating
  15. Z

    Update Code

    i fixed this but still it's Not updating
See more
Back
Top Bottom