Recent content by JimRyanVB

  1. J

    Populate a ListBox from Access Datafile

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

    Question Trying to use the INSERT INTO Query Statement

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

    Question Trying to use the INSERT INTO Query Statement

    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?
  4. J

    Question Trying to use the INSERT INTO Query Statement

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

    Question Trying to use the INSERT INTO Query Statement

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