Search results for query: *

  • Users: johnuk4
  • Content: Threads
  • Order by date
  1. J

    SQL update boolean

    Hi, I am having a problem updating my database when the user changes a boolean value in my datagrid. Basically i load a dataset into my datagrid from here the user can click on the yes/no box to say they have read it. The user then clicks an update button with the following code which i got from...
  2. J

    Updating database

    Hi have a pretty basic knowledge of programming so just wanted to know if anyone could give me a little assistance. Basically I i have created a query which shows results from a database into a datagrid. One of the columns is called resolved flag (basically used if the user wants to mark this...
  3. J

    SQL Select Problem

    Hi, Sorry if this is a tad trivial however my knowledge of sql is fairly basic. The problem is with the following select statement, i'm not quite sure how to search for the string "212". I know that it is just a matter of having the quotations in the right place, but i cannot seem to work this...
  4. J

    Show Value in combobox instead of blank when you load an array

    Hi, Basically im updating a comobox by inserting items. The problem is when it is updated the value the user sees is nothing. Does anyone know how to show the first value of the insert when the system is running instead of having the white space until the combo box is clicked. thanks john
  5. J

    An unhandled exception of type 'System.NullReferenceException' occurred in

    Hi, Im getting the following exemption when trying to show a form: An unhandled exception of type 'System.NullReferenceException' occurred in HelpDeskLoggingSystem.exe Additional information: Object reference not set to an instance of an object. I have declared the form i want in the...
  6. J

    Validating input problem

    Hi, As you will all tell from reading this i am a novice so be warned. Basically iv been trying to validate user input however struggling to get the right if statement to work and what format to use. As you will see from the code below i have 4 textboxes and i just want a simple if statement...
  7. J

    Inserting date to access problem

    Hi, sorry if this is a bit trivial but im a bit of a beginner. Im trying to write a datetime into an access database using the following code: Private Sub btnLog_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLog.Click Dim HardwareId As String Dim Staff As String...
  8. J

    SQL insert problem

    A problem i am having is that i need to enter a value for the Hardware_Problem_Id which is set to autonumber in the access database. Am i right in thinking that you use null? Also could anyone tell me how you would include a time and date stamp in the string, here is my attempt so far SQLStr4 =...
  9. J

    INSERT Problem with string

    Hi (again) sorry to be a pain if uv already answered one of my questions. Iv got an insert sqlstring which when executed give an error stating there is something wrong with the statement: SQLStr4 = "INSERT INTO Hardware_Problems Set Hardware_Id='" & HardwareId & "', Staff_Reported='" & Staff &...
  10. J

    Another simple SQL problem

    Hi, im trying to get a value from a combo box to work in an sql string. Just wondering if anyone could tell me what is wrong with the following sqlstring in the 'cboPrinterMake' area: SQLStr2 = "SELECT Hardware.Hardware_Model, Hardware.Hardware_Make FROM Hardware WHERE...
  11. J

    SQL problem -end of statement expected

    hi, Im sure this is really easy but i have a very limited knowledge of programming unfortunately. Basically iv got my sql string as follows: SQLStr = "SELECT Hardware.Hardware_Make FROM Hardware WHERE (((Hardware.Hardware_Type)="Printer"));" but it gives the error when compiled "End of...
  12. J

    Removing Duplicates From a ComboBox

    Hi, iv got this problem iv been trying to solve for some time now by looking at examples etc of others code. Basically i am inserting data from a access db table, to fill the data for a combo box. I have successfully done this using the following code, however im trying to find away to insert...
Back
Top