Search results

  1. M

    ComboBox Values

    Finaly I get to ask a simple question. I have some ComboBoxes and I want to do two things with them: 1) Make there be a value in it rather than blank then the form loads (it is populated by the properties tab rather than in the code) 2)Not allow anything other than the values in the list to...
  2. M

    SQL selecting mulitiple records

    That did it, i appreciate that. Thanks
  3. M

    SQL selecting mulitiple records

    I am try to create a data grid that will select all users with a surname that is stored in a variable that has been entered earlier. The code below is there to quickly check the database to see if there are any records of that surname, the next section which will compile a DataGrid is going to...
  4. M

    Sorting Columns

    That's the one, i got that myself turns out that it was how to put it in to the statement that got me. Thanks for that guys
  5. M

    Sorting Columns

    All I want to do is get the first column from the grid created below to be in the format of last booking ref first. Can I find the resource on the web? No i can't! Any one?? SELECTS ALL BOOKINGS THAT RELATE TO THE CUSTOMER NUMBER Dim da3 As OleDb.OleDbDataAdapter = New...
  6. M

    Stoping an aplication if an error is spotted

    Figured it out by accident. Exit Sub stops it!
  7. M

    Stoping an aplication if an error is spotted

    I have a try catch set, and if the error message box is displayed the user clicks OK and the finally statement is executed. What I'm after is to stop the application so that amendments can be made, Any ideas?
  8. M

    Filling multiple labels with data from database

    What I am trying to deicide is whether I should use multiple datareaders to store the the individual values or if I should query the data an stash it in a dataset then bind the result in set to the labels. Which one should I use and is it doable?
  9. M

    DataGrid Displays

    I think that I am in the correct place for this one. I have two questions about the display off data grids, 1) Is there any way of changing the titles of the fields displayed. For example it presently displays the field name from the DB (custID) rather than the nice Customer ID that I want it...
  10. M

    The label doesnt want to display the variable

    Yep, Thats my face gone red. Thanks for that
  11. M

    The label doesnt want to display the variable

    Hi guys/Girls, I have a variable the stores a total cost the is received from a database (Access). What I am getting is an error saying that the value type Integer can not be displayed in a label, nor a text box, in fact any method of displaying it yields no result. The code I am using is...
  12. M

    Insert into MySql using

    can you post the variables that you are using to store the data
  13. M

    Running access queries in background

    I think that I get what you are saying, however I think that we would need to see an example of the code that you are using. I believe that pulling sql code directly out of access and place it in will not work as you need to use the formal sql in the application. Post the code and we...
  14. M

    Insert Command

    I am trying to get this to run an insert into the database. I keep getting an error saying that it is missing a ;. I don't really get where that would go. Any one? The actual method works in other places of the application so it must be a syntax problem. ' Creates the OleDb connection...
  15. M

    Running Totals

    Thanks for that, figured it out straight after I clicked the submit button. I mover the running total variable to the top of the form and then it just worked. Thanks again
  16. M

    Running Totals

    I am trying to get some values that have been stored in variables to add togeather. I have a form that calculates a total for the person before adding their personal details to a access DB. The total for the person is added to the grand total and the form is reset (not reloaded), then the...
  17. M

    sql and variables

    That did it! Thanks
  18. M

    sql and variables

    I am having a problem with an sql statements in my form. The DB is access and the sql is as follows: SELECT [firstname], [surname], [activityId] FROM tblTraveler WHERE [bookingID] = bookingBooking is a integer variable, I am not to sure if I have entered the variable correctly into the...
  19. M

    Data Grid for confermation screen

    I have managed to get to the point in a project where I must display a summery of a booking. The details that I have stored in an access database are as follows: First Name, Surname age and activity I need to get these to display in a data grid so that the user can confirm the booking. This...
  20. M

    Passing Variables without making them Global

    Problem is resolved. Thanks for the help that everyone gave me on this, the main problem was in the sql statement. I was trying to do a query that would return the value 0 every time that it ran hence the problem. Also I had the sql in the catch statement and as a result this wouldn’t run...
Top Bottom