Search results

  1. S

    Syntax for variables in docmd.runsql

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

    At most one record can be returned by this subquery

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

    At most one record can be returned by this subquery. (Error 3354)

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

    Data type mismatch

    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...
Back
Top Bottom