Search results

Great thanks Wayne!

Sorry guys, i hadnt put in course codes for some of my testing students, it now works. One problem with this is that occassionally there will be a student who does not have a course code - how do i get around the problem of them having to have a course code to get appended?

Thanks for all your suggestions but unfortunately none of them are working, I have no idea why this is. I have test data in there that should be moving into tblFinalYrs but its not. Any ideas why? p.s: i going to subsequently delete these students from tblStudents Monkier, just moving them first

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

Ive Gemma ive tried query design pane to no avail. I dont think i am getting a random item matching the query parameters because its selecting tutors in order of their tutor code just from tblPreferences

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

Thanks Rolaaus, i had tried using 1 recordset but it got too complicated but once i put it into query design i got it - thanks!

Sure: tblCourse CS_CODE CS_NAME CS_SCH_NO CS_FAC_NO e.g. TR001 History 2 1 e.g. TR801 Nursing 57 3 tblStudents STU_ID STU_COURSE_CODE STU_TU_CODE e.g. 1...

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

Thank you - i wasnt sure of the syntax

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

That's great - thank you very much!

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