Update sql textbox

Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. 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 currency but still error. Is there a solution? Your "field size" property of the table is probably set to long integer.

Needs to be single, double, or decimal. Where is Getalwaarde declared and what is it declared as? I believe there may be an issue with the regional settings if you are using a comma instead of a point as the decimal seperator in the regional settings. Not sure what the work around is.

Facebook Like. Twitter Tweet. Be a part of the DaniWeb community. Sign Up — It's Free! Reply to this Topic. This topic is old! No one has contributed to this discussion in over 9 years.

Are you sure you have something valuable to add to revive the existing conversation? Consider starting a new topic instead. Otherwise, please be thoughtful, detailed and courteous, and adhere to our posting rules. Edit Preview. H1 H2. Post Reply. Broken Link. Go Back to the Post Continue Anyways. Share Post. Permanent Link. Insert Code Block. Updated 5-May am OriginalGriff.

Add a Solution. OriginalGriff 5-May pm. Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know. Top Rated Most Recent.

Accept Solution Reject Solution. Hi , Check this C. Copy Code. Posted 5-May pm Mohamed Mitwalli. Posted 5-May am Darshan. Add your solution here. Toint64 instead of Convert. Toint32 — Rahul. Linga Linga 9, 9 9 gold badges 47 47 silver badges 94 94 bronze badges. I think cause it's bigInteger not int — user In fact if you are using AddWithValue, you don't exclipitly convert that to an int value, because it will automatically be converted and inserted as well; — user Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.