Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by fedum

  1. fedum

    update a table with a decimal value from a textbox in a form with vba

    Debug result Update tblVerkoopKassa Set [TotaalBruto] = val('12,45') where VerkoopKassaId = 2096 I changed it in: strSQL = "Update tblVerkoopKassa Set [TotaalBruto] = (""" & Getalwaarde & """) where VerkoopKassaId=" & gintTicketnr & "" debug result Update tblVerkoopKassa Set [TotaalBruto] =...
  2. fedum

    update a table with a decimal value from a textbox in a form with vba

    I think I have found a solution!!! If I use this instruction without the VAL than it is working!!! Thank you for your help without it I was still trying
  3. fedum

    update a table with a decimal value from a textbox in a form with vba

    In the post on MS they used this syntax strSql = "Update tblVerkoopKassa Set [TotaalBruto] = val("""& Getalwaarde & """) where VerkoopKassaId=" & gintTicketnr &"" debug result Update tblVerkoopKassa Set [TotaalBruto] = val(" & Getalwaarde & ") where VerkoopKassaId=2090 but still no decimal
  4. fedum

    update a table with a decimal value from a textbox in a form with vba

    This is the debug result Update tblVerkoopKassa Set [TotaalBruto] = val(" & Getalwaarde & ") where VerkoopKassaId=2090 Getalwaarde hat a value = 12,12 but in the tabel it is 0 I check the post on MS
  5. fedum

    update a table with a decimal value from a textbox in a form with vba

    Sorry, I had to break the contact yesterday. I try the code! Ok! If I use youre last code I get the same error that the update contains a syntax error.
  6. fedum

    update a table with a decimal value from a textbox in a form with vba

    Result from the debug 2.36 236 I don't think the regional setting is the problem. I have read about this before because I thougt also that would be the problem. Sorry
  7. fedum

    update a table with a decimal value from a textbox in a form with vba

    Debug result Get 2,36 Dim Getalwaarde As Double is declared as double
  8. fedum

    update a table with a decimal value from a textbox in a form with vba

    Yep: Getalwaarde = [frmKassa Subformulier].[Form]![txtAlgTot] DoCmd.RunSQL "Update tblVerkoopKassa Set [TotaalBruto] =" & Getalwaarde & " where VerkoopKassaId=" & gintTicketnr &
  9. fedum

    update a table with a decimal value from a textbox in a form with vba

    Sorry, no it is set to double. Thanks
  10. fedum

    update a table with a decimal value from a textbox in a form with vba

    Hi, I would like to update a table with a decimal that is in a textbox on a form. The problem is when I use DoCmd.RunSQL "Update.... I only can update an Integer. I tried the conversion whtit VAL, no error but the deciamls are gone! The type in the table is decimal. Tryed other types like...
  11. fedum

    filterOn in Access 2013

    May I ask you for an example please. Thanks
  12. fedum

    filterOn in Access 2013

    Ok filterOn is working. Thanks. I can see that the query is filtered but the strange thing is that when Excel opens I got all the data and not the filtered ones. The query is saved with DoCmd.Close acQuery, "qryKlantenlijst", acSaveYes or not???
  13. fedum

    filterOn in Access 2013

    The code is not correct! Before the Me.Filteron=True there is standing Me.Filter=strFilter.
  14. fedum

    filterOn in Access 2013

    The code is: Private Sub btnOk_Click() Dim filterStartPostcode As String Dim filterEindePostcode As String Dim filterNaam As String Dim filterWaarde As String Dim strFilter As String On Error GoTo Err_afhandeling Select Case fraFilterkeuze.Value Case 1...
  15. fedum

    filterOn in Access 2013

    Dear combo, If I debug and put a breakpoint into the code I see that it stays FALSE. Is this not a good way to check? Thanks.
See more

Part and Inventory Search

Back
Top