Results 1 to 15 of 15
  1. #1
    Join Date
    Jan 2005
    Location
    Oldbury
    Posts
    5

    Unhappy Unanswered: Please Help Me!!! I'm struggling with all of it...

    Hi Everyone,
    I'm 17 and I'm studying at college for a National Diploma in Computing. I am trying to create a Microsoft Access Database for an 'Athletic Club', using the following fields:
    ID Number,
    Gender,
    Start Time,
    Finish Time,
    Race Time,
    Member Status (Using the abbreviations- Rcm, Ocm and Ncm.)
    I am trying to create a combo box with a tick box thing, but it doesn't want to work for me! I've put in the validation code for the member status as 'rcm' Or 'ocm' Or 'ncm' But it keeps saying the code is wrong.
    Please help me as I'm really struggling with this!
    Thanks,
    Sam xxxxx

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    A combo box with a tick box thing?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jan 2005
    Location
    Oldbury
    Posts
    5
    yeah.. I think that's what it is? I haven't touched anything of it because when I did it last time, I really messed it up! The database data type for this field is left to text, and the display control is just a textbox. I'm am so confused!

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Perhaps you should look into using a seperate table for member status, then referencing it by status_id?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Jan 2005
    Location
    Oldbury
    Posts
    5
    what?! I'm sorry I really don't understand any of this. So would I make a seperate table with member status on, and then do what?

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Then ask your instructor for clarification on master detail relationships.

    No seriously, your missing some fairly fundamental stuff here and you will continue to struggle until you really nail it down. I would strongly recommend seeing if you can score some extra time with an instructor or perhaps a well versed classmate for a little assistance.

    It's vital you figure out how to do this stuff on your own, you're going to be dead in the water later if you don't.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Jan 2005
    Location
    Oldbury
    Posts
    5
    Hiya,
    Thanks for all your help, I'm sorry about wasting your time, I'm just struggling so much! Thanks again,
    Sam xx

  8. #8
    Join Date
    Jan 2005
    Location
    Oldbury
    Posts
    5
    Actually can you help me with the validation code? I've put 'rcm' Or 'ocm' Or 'ncm', but that's what isn't working. What have i done wrong?!

  9. #9
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What do you mean by validation code? Validation rules at the table level? List values in a combo box?

    I suspect this issue would resolve itself with a bit better table design. If you use a seperate table for these codes as suggested, then it's a simple matter of enforcing referential integrity.

    There are lots of accessable tutorials for getting your feet wet in relational database design if you're not comfortable asking an instructor et al.

    The problems you're running into are a good illustration of why solid schema design is important for eliminating unnecessary headaches later.

    Google around for some access tutorials. Pay special attention to theory behind the exercises instead of just following along. You'll thank yourself later.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  10. #10
    Join Date
    Nov 2004
    Posts
    32
    I think part of the problem here is database theory. A validation of hte type that is being asked for ('rcm' Or 'ocm' Or 'ncm') sounds like information that should be held in another table and referenced in a one to many relationship.

    It would need a lot of explanation about tables (entities), row (tupples) etc for this to start to become clear.

    One minor thing:

    Start Time

    this might be better as

    Start_Time

    If you are going to write code to manipulate any of these fields it's easier if they're one word field names (just my own prejudice I suppose).

  11. #11
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Red face

    Hi Sam,

    Please do yourself a favor and listen to the advice given here, as it is for your own good. Seems you jumped all the way to the 5th floor without even really understanding the ground floor, the foundation. A good book on basic Relational Database design, be it Access or whatever is one by M. Hernandez called "Database Design for Mere Mortals". But any book on relational databases can give you a basic understanding of how it all works. Even one of the "for Dummies series of books. I think Access for Dummies is pretty good for a quick understanding.
    You're in college studying computing, then your instructor should be your first line of help. If you really don't understand, don't be ashamed to tell them, as that's what instructors are there for. Otherwise nothing said here will do you any good. If you don't know the fundamentals, we will all be speaking like Portugese to you. This is all meant to do you much good.

    have a nice one
    BUD

  12. #12
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    I would go along with what Bud just said.

    It may just be me, but we cover the fundamentals of database design in our Standard Grades (due to me living in Scotland), and go into more detail at Higher level, then even more at Advanced Higher Level.

    It does make me question the English Education System more than just a bit (No im not being a nationalistic Sottish bigot. Im English.), mainly due to the seeming lack of teaching anyone anything as basic as how to create a database, no matter how simple.

  13. #13
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by cruickshanks
    I would go along with what Bud just said.

    It may just be me, but we cover the fundamentals of database design in our Standard Grades (due to me living in Scotland), and go into more detail at Higher level, then even more at Advanced Higher Level.

    It does make me question the English Education System more than just a bit (No im not being a nationalistic Sottish bigot. Im English.), mainly due to the seeming lack of teaching anyone anything as basic as how to create a database, no matter how simple.
    There's alot more to question about our education system then whether or not database theory is standard curriculum. Trust me.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  14. #14
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    That's true enough, but i was just trying to stick to the subject at hand.

    Just going off topic for a second, if the MP's took a pay cut, and actually did work, things would probably run alot smoother.

  15. #15
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404
    cruikshank - I agree with both you and Teddy. As far as the MPs are concerned, a few less "fact finding" trips might be helpful.

    A few years ago our local MP turned up in the Bahamas/West Indies on a "fact finding" mission about tourism. He was there for a couple of months or more, and the local university, which specialises in Tourism complained that they got no feeback from the guy.

    I think you'll find a lot of our MPs tend to go on this sort of "fact finding" mission during the drab British Winter months. I gather the South Africans hotels are getting to the stage of holding hotel suites for them!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •