Search results

Hello, I am trying to to convert a number to a 'Standard' Format, example: 1234 = 1.234 However, when i use the code below i still get 2 decimals. Format([TachostandLookup], "Standard") And when i use this code i get a non formatted number + ',' at the end Format([TachostandLookup]...

Hi, I'm trying to update a record in my database. Code: Dim UpdateQuery As String Dim currentOfferteNummer As Long currentOfferteNummer = (Form_Main.Hidden2) UpdateQuery = "UPDATE [Offerte Items] SET [Item 1] = 'test' WHERE [Offertenummer] = '" & currentOfferteNummer & "'" After running the...