When I run this it successfully opens the datatable Color and returns a RecordCount = 179
However when I attempt to populate the lstColors it comes up empty?
Public Class frmColors
Dim Colors As New dbControl
Private Sub CmdExit_Click(sender As Object, e As EventArgs) Handles...
What I was trying to say was before my code was...
Dim Custno AS String
Once the txtHphone.text phone number was input 6153563232 I was loading the last 7 digits into the Custno variable and that gave me the error
"The field is to small to accept the amount of data you attempted to add.
Try...
You were both right, I had to create a hidden Custno.text box on the form to hold the CustNo as somehow the CustNo text variable I was using would not work?
Yes the max length is set to each text box and I have stepped thru each text box and am assured that the data from each is less than the length required in the database.
Thanks Jim
I can open the database and extract all information to my form.
But when I enter new information into the same form and click Add
which simply runs the AddUser Sub I get the following message below
"The field is to small to accept the amount of data you attempted to add.
Try inserting or pasting...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.