Results 1 to 14 of 14
  1. #1
    Join Date
    Mar 2008
    Posts
    8

    Unanswered: help with access database project, Karate Club

    I'm making a database in Microsoft Access for my end user who runs a karate club for my a2 coursework and I need to store members details, and have a register so he can monitor absences. The classes are taught by ranks, beginner, intermediate and advanced so there needs to be three registers. My end user also wants to monitor lesson fees so there needs to be fields with paid or not paid. Im having no troubles with storing members details but seem to have hit a dead end with the register. If it's at all possible to make a register in access can anyone please help me to make it. Thanks.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You can make just about ANYTHING with Access. And yes we can help you out. Just post up questions when you hit a wall.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Mar 2008
    Posts
    8

    Thanks

    Thank you.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    No wurriez!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Mar 2008
    Posts
    8

    Stuck

    I'm stuck can anyone help me please.

    I've made a table for beginners details where their details are stored and for new members who join. I've made the register for beginners(need 2 more for intermediate and advanced which I will do exactly as beginners) a table with 6 fields Date, Member Name, Present/Absent Paid/Not Paid so it looks like this.

    l__Date____l__Member Name__l__Present/Absent__l__Paid/Not Paid__l
    01/03/2008 lGurpreet Dodd____lPresent__________lPaid____________l

    I have a lookup list for member name so I have to select the member manually
    I need help on two problems:

    1) A couple of days ago i set it so when a new member is added to the beginners table their name is automatically added to the register according to member ID for example the student who has member ID 1 would be at the top of the register, 2 would be second etc. When someone new is added they would be sent straight to the bottom. Something happened and now it doesn't happen anymore. I forgot exactly how I did it. I'm sure it was to do with lookup but now that only brings up a drop down list. Does anyone know how I could set it again?

    2) The register is made so the next lesson I have to drag it down to when the list of students finishes and set the date of the new lesson and set all the members names again like this:

    __Date____l__Member Name__l__Present/Absent__l__Paid/Not Paid__l
    01/03/2008 lGurpreet Dodd____lPresent__________lPaid____________l
    __________lBlah Blah_________lAbsent__________l_______________l
    __________lBlahh Blahhh______lPresnt__________lNot Paid_________l

    08/03/2008 lGurpreet Dodd____lPresent__________lPaid____________l
    __________lBlah Blah_________lAbsent__________l_______________l
    __________lBlahh Blahhh______lPresent_________lNot Paid_________l

    do you think this is a good way of doing it bearing in mind there are around 20 students in that class? Although it may be good for queries for example. I could make a query using the fields date, Member Name and Present/Absent fields. For date i could set 01/02/2008 as the criteria and for present/absent I could set absent as the criteria which would then show me a list of all the students who were absent on that date.

    Hope I haven't confused or annoyed anyone lol. This courseworks doing my head in.

  6. #6
    Join Date
    Mar 2008
    Posts
    8
    I've solved it. I did

    Name________ Date___ Date_____- Date
    Gurpreet Dodd present Absent Present

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Glad you solved it.

    Gentle reminder it's preferable that if you have a new problem, create a new topic. It's good for search engines!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Mar 2008
    Posts
    8
    Thank you, but i'm having some trouble with my queries. Appreciate if anyone can help. I've created a select query for absences by linking it to the register I made like the one above. The Query design is shown in t
    he link.

    http://i289.photobucket.com/albums/l...d/untitled.jpg

    The query only gives me the name of students who were absent for all the dates. Does anyone know how I can change the query so I only get students who are absent on any date. Or would I need to create a query for every date? Thank You.

  9. #9
    Join Date
    Mar 2008
    Posts
    8
    Query
    http://i289.photobucket.com/albums/l...untitled-1.jpg

    Register
    http://i289.photobucket.com/albums/l.../untitled2.jpg

    How would i get only the absences to a seperate table

  10. #10
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    If you're storing every date as a field in the table (which is looks like you're doing), I'd HIGHLY recommend considering a redesign of your table structure or you'll hit a wall (which I think you've already encountered.)

    Think about instead having a relational table where you have fields in the relational table like:

    ID (autonumber field for relational table)
    MemberID (linking back to MemberID autonumber field in main table)
    DateOfClass (defined as date field type)
    MemberStatus (i.e. which will have values such as: Absent, Present Not Paid, etc...)


    Your query then will be much easier to find absences.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  11. #11
    Join Date
    Mar 2008
    Posts
    8
    yeh that sounds better but what do you mean by DateOfClass (defined as date field type)

  12. #12
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The date the class is held on?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  13. #13
    Join Date
    Mar 2008
    Posts
    8
    I spoke to my teacher today and he goes that instead of having my register set out like

    Namel 04/03/2008l 11/04/2008

    I should have the fields as Name, Date and payment and have the default value of date set as "=DATE()" which will then show the field as the current date and then when i wana make queries I should have a paparameter as "date?" so then I could choose to view outstanding payments from any date I want. Will that work?

  14. #14
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yup.

    Sure will
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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