Search results

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

Thank you so much for the advice Steve! I am going to go away and put it into action and then see what happens next!!! :D

Thanks for such a speedy reply ash1123! I have now joined the tables up, PK to FK as you suggested. But you also say "make form". I know how to make a form, but can you please be more specific? What should be on the form? Please talk to me like i know nothing, as that is how i feel at the...

I work at a University and I am trying to put together a database that will store details about our students, the classes we provide and the instructors that teach the classes, but I need advice on how to link the tables so I can then run reports that will show a list of who is attending each...

Hi Everyone, My name is Clare, I am 30 and recently relocated from the UK to the UAE. I work for a university in Abu Dhabi as a personal assistant. I've always been interested in computers and all the amazing things they can do! But I’ve never really had someone I can go to for help. I...