Recent content by Spocks

Thank You pr2-eugin your code worked.

Private Sub cmdNew_Click() Dim Response As Integer Response = (MsgBox("Are you a new student?", vbYesNo, "New Student")) If Response = 6 Then TempName = InputBox("Please enter your name", "Enter A Name") TempID = InputBox("Please enter your student number"...

TempName and TempHouse are variables. The parameter value boxes pop up with the title "enter parameter value" with the text being the value of Variable.

Hi all. I'm trying to execute an sql query with variables, but it won't work. Code is below. DoCmd.RunSQL "INSERT INTO Students ([Student ID], [Student Name], [House]) VALUES (" & TempID & ", " & TempName & ", " & TempHouse & ")" The TempName and TempHouse won't work and parameter value boxes...

Hi all. I'm trying to return a list of students in a particular team who have not attended a certain number of sessions at a gym, between two dates. For some reason i get the error. At most one record can be returned by this subquery. (Error 3354). I don't understand as i have the LIKE in there...

I'm found no answer on google that's why I'm here...

Hi and thank you in advance. I'm trying to create a listbox that populates on the following query however i get the following error. At most one record can be returned by this subquery. (Error 3354) This is my SQL: SELECT Students.[Student ID], Students.[Student Name] FROM Students WHERE...

Thank you Paul! I'm just curious, why does it work with the login part of the code with the textbox with single quotes?

Hi all! I've been working on a part of my database in which the entrance and exit time of a persons attendance at a gym is recorded. For some reason i get the data type mismatch error for logging out. I don't know whats happening as the log in part of the code works fine and the fields in the...