Recent content by bfgweb

A big 'thank-you' to all who have offered support on this matter; sorry not been active for a few days ... sadly attended best friends funeral on Monday and struggling to get back into the world of work :(. However, it is half-term holiday for us next week so will have time to work on this...

Hi Marlan, Thanks for your support - apologies for delay in my reply, just got back home after working away. I'm using Access 2010 - I have setup a text field in my student table and in that field have entered the path directory of where the photo is stored for each student. This works fine...

Hi all, I have a database of students with an image (photo) of each student on their personal details form. If their photo does not exist I want access to display the school logo by default on their details form. Currently, if the photo does not exist Access generates a runtime error with...

Thanks for the guidance Recyan. Will work on it over next couple of days and let you know how I get on :). Your time is much appreciated.

Hi Recyan, Thanks for quick reply, much appreciated. One STUDENT can take many COURSES over a period of TIME. One COURSE can consist of minimum 1 to many UNITS The TASK is essentially related to the UNIT of the COURSE One UNIT can have 0 TASKS or many TASKS The EXAM is essentially related to...

Okay here I go, holding my hands up first and confessing to being totally at sea when trying to initially structure a database. Give me the task of querying, creating forms and generating reports I love it but the initial stages of normalising etc just drives me insane ... I am trying to set...

Wow. now that's what I call a support forum - such a prompt reply! Many thanks - will give that a try in the morning.

Hi, hoping the solution to this question is not so basic to make me appear a fool ;) This is a question about a 'student records database' providing teachers with their appropriate class lists. I have set up a query with two sets of criteria. Firstly, [Which year do you want eg 7, 8 or 9?]...

Many thanks for all your suggestions and comments. I will try out a version of jzwp22's later today and feed back. :)

I am creating a student records database. All 1100 students will have 7 assessments each year eg E7 (English year 7), E8 (English year 8), M7 (Maths year 7) etc. All work is assesed via Assessment Criteria (which are the same for all subjects eg 311, 312, 312, 411, etc (tick box) Therefore...