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...
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
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,
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 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...
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 (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 &...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.