Search results for query: *

  1. H

    searching with date value

    SELECT CustID, CustName, CustAddress, CustPostcode, CustTel, CustEmail, CustNotes, CustRoom, CustStayArrive, CustStayLeave FROM tblCustData WHERE CustName = '" & SearchBox.Text & "' Change the last line to WHERE CustName like '%" & SearchBox.Text & "%' where the % is the wild card character...
  2. H

    Question Working with ListBoxes in VS2005

    The ListBox1.Items is a collection of objects. You do not need to move this into an array. You can use ListBox1.Items.Item(0) to reference the first item in the ListBox for instance. Hope this helps.
  3. H

    Question Delete files,folders and subfolders after 2 days

    As was previously posted, you need to use DirectoryInfo and FileInfo to get the information needed. The answer has been posted in this thread. Private Sub CheckFiles(ByVal path As String) Dim di As New System.IO.DirectoryInfo(path) For Each childDir As...
  4. H

    INSERT,SELECT,INSERT into DB

    Yep. It looks like your ClientID field in table Criteria is set to integer, and you are passing it text. You need to change the ClientID field to varchar or char.
Back
Top