Search results

  1. A

    INSERT and DELETE Problem

    Im still having problems with this! It just doesnt do anything - no error messages or anthing. PrivateSub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Title AsString = TextBox1.Text Dim Artist AsString = TextBox2.Text Dim Tracks AsString...
  2. A

    Another Sql Problem!

    Thank you again for the help. I have learnt alot over the last few days. :)
  3. A

    Another Sql Problem!

    Sorry guys, its me again. Im try to create a search, so the value of what is entered is compared to the information in the databse and the values that match reurned and display in the list. Now, if i use any of the number values as my search criteria they work - e.g id,Tracks etc. However, if...
  4. A

    SQL statement problem

    Im having a problem with sql statements again. I keep getting an error saying my syntax is invalid, although i cant see where. Have i done it totally wrong? MANAGE TO SOLVE IT WITH THE FOLLOWING CODE PrivateSub add() Dim sa AsInteger Try Title = TextBox7.Text Artist = TextBox8.Text Tracks =...
  5. A

    Resetting an array

    I tried that, and all i get is the save or load file error. :mad:
  6. A

    Resetting an array

    Opps. Sorry, i posted my half edited "messing" around code. Hvae edited it now. All i need to know is where to put the array.clear option. :)
  7. A

    INSERT and DELETE Problem

    I have doen what you said, although im still having problems. It just doesnt do anything, despite me setting the permissions on the folder and everything else i can think of. Dim strTitle As String Dim strArtist As String Dim intTracks As Integer Dim intRunningTime As Integer Dim intId As...
  8. A

    Resetting an array

    Im still having problems with this. Below is the code I have, which prompts the user to save the current file, before opening a new one. However, instead of clearing the listbox and displaying the new information from the file just opened, it also displays the old data since it is in the array...
  9. A

    Search array contents and display

    Thank you for your reply. Guess I have lots of learning to do yet, but im getting there slowly. I have the following, although i get an error as shown below. Dim input As String input = InputBox("Enter Artist Name", "CD Input Box", "", 1, 1) ListBox1.Items.Clear() For Each aCD As...
  10. A

    Resetting an array

    I have a listbox, that im reading information into from an array. When the user hits the load button, i want the information to be cleared from the listbox (which is easy), although it isnt working, since the information is still in the array. How do i clear the array and set it back to empty.
  11. A

    Search array contents and display

    I have the following code where im trying to set it so that when a user enters an artist into an input box, only the records that match that artist are shown. Im having a problem, where by, it will output the data as many times as thee are records. I guess this is since it is not moving to the...
  12. A

    INSERT and DELETE Problem

    I have the following code for inserting and deleting information from a database named CDList.mdb. Im having problems in that, when i try and add or delete nothing happens. Have i got something wrong? The user basically enters the information into a number of text boxes, and hits the button...
Top Bottom