Recent content by ClareLou80

Hey Chris, I'm pretty new to all of this too, but here's my opinion. I'm also assuming you are using access 2007? The Text field is an alphanumeric field that can hold up to 256 characters, so yes, you can store numbers in there. You may also be better off letting the Autonumber be your...

For some strange reason, the spreadsheet will not attach, so i will write what i mean below: So, if i want to know Class and students, then i would want it to look like: GOLF John Mary Simon If i want to view the classes 1 student is taking: JOHN Golf Yoga Boxing If i want to know...

Thanks for taking the time to look over this. I've had a play with it, and i'm wondering if what i need now comes down to queries and forms? The thing is, it still does not show me an individual student and the classes they are enrolled on and i still have to enter the student group repeatedly...

Thank you for your support and kind words and even messaging me despite your deadline! It is really appreciated. I look forward to hearing from you.

I'm starting to feel like an idiot!!! Ok, so i understand the principal of what you are saying (i think). I need groups and definite questions: If i want to know which student is in which class, i need: tblClass+tblStudent LINKED via tblJunctionClassStudent. This should tell me who/which...

Ok...i've attempted this, played around with the tables and forms, and its still not quite where i want it :confused: I want to be able to go to a class, for example, Golf, and then enter all of the dates that golf will take place for the term. These dates would then be fixed to this class...

Thanks Mr B! I will give it a go and see what happens. I understand what you are saying. I need a junction table...! :)

I have been working on a database that will track the following: Students details Classes provided Dates of classes I keep hitting brick walls. I can either get it so i can see all of the students in a particular class OR i can get it so i can see the specific dates of a class. But failing...

Firstly, thanks James! Secondly, I can create a query, but i was only able to create one specific one, eg. show me all of the students in the golf class. Eventually there will be many classes, so i'd rather not create a specific query for each class. Is there a way to do it so as that when the...

ok, stressful day! NOW it's attached! :o

Ok, so with some support and advice from this forum, the internet and various online tutorials, i have come so far with my first database, but now i need some more advice please. 1. I need to be able to enroll students on classes. 2. I need to see all the students that are enrolled on a...

Jdraw, i would just like to say thanks for taking the time to post these links! They have certainly given me something to think about when dealing with my own database issues.

Once again Steve, THANKS!!! Your help has been invaluable and much appreicated.

WOW! thanks Steve, you have quite possibly saved me a mental breakdown! Can you suggest somewhere i could learn about combo-boxes? What you have done works perfect and i can see how i could use something similar in other scenarios. Thanks again!

Ok, so I have ammended the tables as you suggested (spaces all gone), added in the enrollment table and also added in a few forms, but still can't get my head around how i enroll a student on a class? If i go to the enrollment table, how would i know which student is which and which course is...