NiallP17
Last Activity: Feb 26 '14, 11:23 AM
Joined: Oct 18 '13
Location:
-
Both variables are empty until the user inputs values from the text boxes and when they click the button it stores them in said variables. -
Do you mean what's in the sub when the button is clicked as the code above is just for the function?Leave a comment:
-
Without the quotes on both.Leave a comment:
-
Title was 'Wifi not working' description was 'The wifi is not working'Leave a comment:
-
The values are from 2 text boxes, the user enters the title of their problem in the title field and the description of their problem in the description text box. These values are then stored in the variables Title and DescriptionLeave a comment:
-
Do you mean what values I am trying to store? Because I get the values from 2 text boxes and the StaffID from a session variable I set up.Leave a comment:
-
I must be missing some then because that's all I have. I'm new to this so I'm not 100% sure how to word it all. What exactly am I missing?Leave a comment:
-
Isn't the SQL in the code?Leave a comment:
-
It's the same code that is posted in the first comment.Leave a comment:
-
That is the SQL I am usingCode:myCmd = New OleDbCommand("INSERT INTO Request (StaffID, Title, Description) VALUES (" & UserID & ",'" & Title & "','" & Description & "')", myConn)Leave a comment:
-
That line of code worked but now I am getting an error on the line
It is saying 'Syntax Error (missing operator) in query expression 'the wifi is not working')'.Code:myDr = myCmd.ExecuteReader
The expression is what i am trying to store as the description in my table.Leave a comment:
-
I'm really sorry but I don't understand what that meansLeave a comment:
-
So I am listing them wrong? How am I suppose to list them?Leave a comment:
-
Do you mean like that? Because Title, Description are underlined blue as 'Too many arguments to 'Public ReadOnly Default Property Chars(index as integer) As Char'.Code:myCmd = New OleDbCommand("INSERT INTO Request (StaffID, Title, Description) VALUES "(UserID, Title, Description), myConn)Leave a comment:
-
Storing data to Access from Visual Studio VB ASP
I am trying to store three values that I take from my web form and place them into a database that I have.
At the minute when I try this, the (UserID, Title, Description) line doesn't accept and the Title and Description are underlined in blue. I have tried putting in & instead of the comma but then it takes it all as one long string.
I have tried so many ways to try and get it to place the right data into the right... -
Problem solved now, thanks for the helpLeave a comment:
-
Yeah that was right. I am now having trouble storing the values into the 3 variables. I believe I must have done something wrong but I have looked online and cannot find a solution. Any help would be kindly appreciated.
It keeps telling me there is 'There is no row at position 2'.
There is a row and that is the row I am trying to access.Leave a comment:
-
Database Error Trying To Get Details VB Access 2007
Hi, I am having trouble storing the values into the 3 variables. I believe I must have done something wrong but I have looked online and cannot find a solution. Any help would be kindly appreciated.
It keeps telling me there is 'There is no row at position 2'.
There is a row and that is the row I am trying to access.
...Code:Function GetDetails() As Boolean Dim myConn As OleDbConnectionLast edited by Rabbit; Oct 18 '13, 09:43 PM. Reason: Please use [CODE] and [/CODE] cards when posting code or formatted data.
No activity results to display
Leave a comment: