Textbox to label

Katie B

Evening all,

Sorry to call on you again, I've have a form that will sign in users from my access database. But the forms only recognise the users input in order to sign them in. Further on I'm adding more detail to the students data. But I don't know how to get the data from the text box on the sign in page over to where more data is added in order for this data to be put in the same row in my table. I hope that makes sense, any advice would be great.

Thanks

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Javeed M Shaikh13y ago
thank you vulpes.
Katie B13y ago
Thankyou Vulpes, I get confused with all the quotation marks.
Riddhi Valecha13y ago
Hi...

Can you share your code ?? I can debug and send it back....
Vulpes13y ago
If ID is a numeric column in the database, then you don't want any surrounding quotes at all:

"WHERE ID = " + txtstudentid.Text;
Katie B13y ago
Thank you Vulpes. Ive tried it, but keep getting the error data mismatch in criteria expression on the execute reader line. I changed the quotation marks around the ID to single quotation marks because it deals in number, but I still get the same error. :D
Vulpes13y ago
The syntax of the UPDATE statement is slightly different. Try this:

"UPDATE StudentDetails " +
"SET [ModuleCode] = '" + lstModCode.SelectedItem + "', " +
"[Modules] = '" + lstboxModules.SelectedItem + "', " +
"[Classes] = '" + lstboxClasses.SelectedItem + "' " +
"WHERE ID = '" + txtstudentid.Text + "'";
Katie B13y ago
Morning Vulpes,

thankyou, I noticed once I out the two lines together. I never thought of using an update statement. The module code and things in square brackets need adding to the table. I'd guess if I put an update statement directly underneath this then the insertion of the modules will relate to the update statement, if that makes any sense.....
Vulpes13y ago
Comparing the two, Javeed has removed the comma after [Classes] and inserted a space before VALUES which certainly needed doing.

However, I think there may be a deeper problem here, namely that you can't have a WHERE clause in an INSERT INTO statement.

If a student with this ID already exists in the StudentDetails table, shouldn't you be using UPDATE rather than INSERT INTO?
Katie B13y ago
Thanks for your reply, i'm still getting the same error message. Can I ask what you changed?
Javeed M Shaikh13y ago
replace your insert statement with this:

"INSERT INTO StudentDetails ([ModuleCode],[Modules],[Classes]) WHERE ID = '" + txtstudentid.Text + "' VALUES ('" + lstModCode.SelectedItem + "','" + lstboxModules.SelectedItem + "','" + lstboxClasses.SelectedItem + "')";
Katie B13y ago
Maybe this will make it clearer...or more confusing. I've added a text box to my form for the user to re-enter their user name, i've then written an SQL statement as follows:

"INSERT INTO StudentDetails ([ModuleCode],[Modules],[Classes],) WHERE ID = '" + txtstudentid.Text + "'" +

"VALUES ('" + lstModCode.SelectedItem + "','" + lstboxModules.SelectedItem + "','" + lstboxClasses.SelectedItem + "')";

But each time I run it I get an "Syntax error on INSERT INTO statement. I tried swapping out comma, semi-colons etc but I cant see it's issue. I'm hoping to get the statement to add the modulecode etc to my database where the txt.studentidfield is equal to the id in my database.

Any help would be great. Thank you
Katie B13y ago
I want to pass the user name the user logs in with to a label in another form. So that when they click a button this data is then put altogether into an access db table. I'm doing the forms in visual studio with an access db behind it.
Javeed M Shaikh13y ago
correct me if I am wrong, I think you need to pass data between access forms, so try this:

your sign in form
' this code will be on click of the login button
Sub GoOnSecondPage()
DoCmd.OpenForm "MySecondPage", acNormal, , , , , "valuetopass"
End Sub

your second form

Sub Form_Open(Cancel As Integer)
If Not IsNull(Me.OpenArgs) Then
SomeLabel.Value = Me.OpenArgs
End If
End Sub