Recent content by rich2912

Thanks for the reply, I have already gone through that as it came up on an internet search, but does not seem to help me, or I cant make sense of it. One of the two. Has anyone ever had to do this? i.e Pick a variable such as age, course, weight etc from a combo box to then merge into word with...

I have made a query in access that takes the value of a list box and on that value, it shows the appropriate results. This value is a course ID, (as in a college course). I want to be able to send a letter to everyone on a specific course, using the same word template with the students name...

Thanks a lot, that was exactly what I was after!!

The query is set up and working, it shows students that appear more than once in the student file, by forename and surname. I have six databases now that would really benefit from a function that runs the query after the students name has been entered. In basic terms, it validates more than...

The query only picks up a duplicate entry when the Forename AND surname are the same (see code) it also then shows you the address so you can make sure that these students don't just share the same full name. The reason for this is that students may apply for different courses via two or more...

I have set up a query to indentify if there is a duplicate entry on a presons name. The query shows the Students forename, surname and their address. I would like the query to run after the surname field is updated on the data entry form. But I only want it to run when the query has identified...