Search results

Thanks for your reply! In the table the value is formatted correctly. I just cant get the same formatted data into a variable. I use this code to put the data into a textbox If i format 'tb_date' as #.###, it just adds a few spaces before the actual text. Edit: Setting #.#### as format for a...

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

Thank you Trevor. I've used the query designer before, but never used the update function :p It works great, thanks!

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