Search results

I want to compare all fields in two tables (one of which has just been imported from excel) They are called tblStudents and tblSIS. Both tables contain exactly the same information. What i am looking for is something that will tell me either if a record is missing from tblStudents (for instance...

Hi there. Is it true that you cannot update a recordset if it has a group by clause? Im trying to make sure that a tutor has space (TU_SPACE) and then decrease their space by one when a student is assigned to them but the following results in "cannot update database or object is read only"...

Hi i have two modules; both contain the code below to insert entries into an excel spreadsheet; this code works for both modules separately. However when i run a sub that runs both modules one after another, the 1st modules entries are put on the spreadsheet but the second modules entries are...

Wondering if someone could help me with a subquery (i only learned they existed today) Is it possible to have multiple criteria in them? For instance i want a TU_CODE where they're in a certain faculty, tu_only is false AND where the number of students they already have (gotten by me trying to...

Wondering if someone could help me out here. My query is trying to insert students into another table if their standing is 4 but not if those students with standing 4 have a course code equal to TR051 or Tr052. At the moment its inserting all students not doing TR051 or TR052 regardless of...

Can someone please help me, this has been driving me mad for days :mad: (sorry about the title) I am trying to find the first TU_CODE that has free space, is in a certain faculty, doesnt have TU_ONLY, and who either does or does not have an entry in tblPreference - but if they do have an entry...

Hello, can anyone tell me where i am going wrong please? Im trying to send an email to tutors who have student/s in a particular school which is entered by use of an input box. At the moment i've created 2 recordsets. The first one finds out what courses are related to that school (as the...

I am trying to move students from one table to another if they have a certain course code. This works by using multiple sql statements but is there a quicker way that combines these? strsql = "Insert into tblWorking ( STU_ID, STU_FORENAME, STU_SURNAME, STU_COURSE_CODE, STU_STANDING ) "...

Can anyone tell me where my syntax error is - i thought that if something is hardcoded like TR0034 it doesnt need any quotation marks? strsql = "Insert into tblWorking ( STU_ID, STU_SURNAME, STU_COURSE_CODE, STU_STANDING )" strsql = strsql & "Select tblIncoming.STU_ID...

I was wondering how you get the value of a variable into a table that is being appended to. Ive tried the code below but the syntax is wrong. Im trying to get the variable replacedate into the OTH_RETIRE_DATE column strsql = "Insert into [tblOther Staff]( OTH_FORENAME, OTH_SURNAME, OTH_DP_NO...

Hello! I was wondering if someone could tell me where im going wrong. Im trying to copy a recordset into an open excel sheet starting where the next empty cell in columnA is (the excel sheet was created in a previous macro, is still open and not saved, and does contain data). My code is the...