Search results for query: *

Ive a question relating to joins, in the code below im trying to find a tutor, who has free space, is in a certain faculty, doesnt have TU_ONLY and who doesnt have a preference for a certain course. Basically it works for the first three criteria but it only returns a tutor who has an entry in...

Ive seen similar posts on this but none of the solutions seems to work for me. Im trying to test if a recordset is null or not. If it is i don't want another recordset to have a value for STU_TU_CODE else i do want it to have a value. I have a few variations, the latest one is below and has an...

Another one for you geniuses, Im trying to assign students to tutors until a tutors chamber is full. I have tried the code below but it wont let me update the space a tutor has left in their chamber. Its says "cannot update: database or object is read only". Does anyone know how i can get...

I have a query that returns if someone has free space (determined by taking the number of students they have from their chamber size) this works fine if those people have students, but if they dont have students they dont show. How do i incorporate that if they have no students their chamber...

Can someone help me with my syntax here. I am trying to send an email to people if they have at least one student in the faculty specified by an inputbox. This works but it sends as many emails as there are students in that faculty i.e: if someone has 2 students in a faculty they get 2 emails...

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). My code is the following but i get an error: Dim...

Is there a way to do something to only part of a recordset. I want to send a mail only to a certain number of people and then go back to a form. Ive tried the following but if doesnt work: Set rs = db.OpenRecordset("Select * from [tblStudents] where tblStudents.[STU_TU_CODE] = " & "'" &...

I have an append query that works well but i was wondering if it is possible to update another field in the table im appending to without that value coming from the other table i.e mark as past tutor when added to this table. My code is: strsql = "Insert into [tblOther Staff]( OTH_FORENAME...

I'm automating outlook (2002)from access and it works fine but i keep getting annoying security statements (A program is trying to access email addresses you have stored in outlook. Do you want to allow this? etc) which are very impractical if emailing to lots of people. I know there's a bit on...

I'm automating outlook (2002)from access and it works fine but i keep getting annoying security statements (A program is trying to access email addresses you have stored in outlook. Do you want to allow this? etc) which are very impractical if emailing to lots of people. I know there's a bit on...

Hi im trying to get access to print out email addresses in a word document using a recordset but while the document is opening nothing is printing out. Is there something wrong with my syntax? Any help please, here's my code: retiring = InputBox("Enter the Code of the Tutor Retiring", "Retiring...