Search results for query: *

Hey, Thanks for the reply, basically i have more then one record in the dataset so not really sure how to use your method with that. Sorry im a beginner at programming so please bare with me. A lot of articles seem to suggest using the dataadapter to update. Would you knwo anything about this...

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

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

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

Thanks for the help

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

Sorry i copied all of the system code to by accident Sorry i copied all of the system code to by accident

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

Hi, thanks for the reply, iv tried to use what you recommended however a few errors pop up. Would you possibly know why i get the errors: Argument not specified for parameter 'e' of 'Private Sub Validate(sender As Object, e As System.ComponentModel.CancelEventArgs)'. and Argument not...

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

Hi, sorry it was me been stupid id left out the sqlCommand.Connection = DBCon sqlCommand.CommandText = SQLStr4 must have been getting late last night! Thanks a lot for the advice though its really appreciated johnuk4

Thanks for that, i was just trying something similar. It got me past the data mismatch however now an error: Error reading database ExecuteNonQuery: Connection property has not been properly initialized. This shows when the insert is executed. thanks for your help john

Thanks, but where would i declared the OleDbType as it says its not been declared when i change it john

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

Thanks very much for the help its finally worked

Still seem to be having the same problem unfortunetly, Here is the code im using to insert however it keeps giving me the error: Error reading database, No value given for one or more required parameters. Iv checked the db and none of the fields are set to required. Sorry to be a pain just not...

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 =...

Hi, thanks for the advise. 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 you tell me how you would include a time and date stamp in the string, here is my...

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 &...

Thanks very much works a treat, i didnt think about SQL not knowing anything about the form components