Hi All,
I am having some problems getting VBA to create an entry into a MySQL backend.
The value I want to enter is from a text box on the form, say with the value of 0.5, and going into a MySQL DB, with the data type of Decimal - Length 5,2
I keep getting runtime error 3759 - Data truncated error message coming up.
I have tried everything I can think of to get it over, and spent a couple of hours yesterday afternoon googling for help but nothing found worked.
I have tried CDec, CDbl, Single, Double everything I can think of.
How can something that should be so simple prove to be so hard
Any help greatly appreciated.
I am having some problems getting VBA to create an entry into a MySQL backend.
The value I want to enter is from a text box on the form, say with the value of 0.5, and going into a MySQL DB, with the data type of Decimal - Length 5,2
I keep getting runtime error 3759 - Data truncated error message coming up.
I have tried everything I can think of to get it over, and spent a couple of hours yesterday afternoon googling for help but nothing found worked.
I have tried CDec, CDbl, Single, Double everything I can think of.
How can something that should be so simple prove to be so hard
Any help greatly appreciated.
Last edited: