Help with MS Access '07? - The Horse Forum
LinkBack Thread Tools
post #1 of 2 Old 09-02-2010, 12:06 AM Thread Starter
Join Date: Jan 2009
Location: Tri-State (IA, WI, IL) area
Posts: 788
• Horses: 7
Help with MS Access '07?

I made a database in Access 2007 that keeps track of all the people and their horses that ride in a local "Under-the-Lights" show series, along with their points/age group/etc, and then runs some queries that show, for instance, everyone over 18's point total in the speed events. (That's how they determine High Points at the end of the season -- Speed vs. Pleasure, and then by age groups.)
Admittedly, I did it halfway for my own amusement, and halfway for practice for a class I'm in.

Anyway, I have it up and running, there's just some tiny things that bother me. Cosmetic details, really, but I'm having fun and was considering presenting this to my club president.

My tables look like this (well, these are the headings and what they point to. :p):

  • Team ID
  • Rider Name
  • Horses Name
  • Age Group
    (Lookup: "12 & Under"
    "13 - 17"
    "18 & Over")
  • Class ID
  • Class Name
  • Age Group
    (Lookup: "Open"
    "12 & Under"
    "13 - 17"
    "18 & Over")
  • Group
    (Lookup: "Pleasure"

  • Show ID
  • Show Name
  • Show Date

Points Awarded
  • ID
  • Show ID
    (Lookup: [Shows].[Show Name])
  • Show Type
    (Lookup: "Pleasure"
  • Class ID
    (Lookup: [Classes].[Class Name])
  • Team ID
    (Lookup: [Teams].[Rider Name] and [Teams].[Horses Name])
  • Points Awarded
  • Placing
    (Lookup: "1st"
    "No Placing")

Question # 1: In the Points Awarded table, under Team ID.... It shows in the table as [Riders Name]. Is there a way to get it to combine [Riders Name] and [Horses Name] and show both? Say, as "[Riders Name] / [Horses Name]".
I considered simply combining the two, manually, in the Teams table itself. But I like being able to say "This person has this many points total"... say, in the instance where I run two horses. I can see how many points I have under Tanner, and how many under Magic, or I can simply query my name -- ignoring the horse -- and see how many points I have on both horses combined.

Question # 2: Is there a way to limit who can be listed under a show? Say, if I'm entering a new record in Points Awarded for myself, in the July Speed show, in the class Barrels 18 & Over. As I'm typing that in, is Access able to narrow down the look up. If I type in "July Speed Show" have it only show Classes (in the [Class ID] column) that are labeled as 'Speed' and not show the ones labeled 'Pleasure'. Then, as I enter "Barrels 18 & Over" into the [Class ID] have it narrow down the [Team ID] lookup to only those teams who are labeled '18 & Over'.
Did that make any sense at all?

Question # 3: In the Points Awarded table, again. Can I set [Placing] to be automated based upon what I enter in [Points Awarded]? All of the UTL shows have the points set the same (1st place = 6 pts, 2nd = 5 pts, 3rd = 4 pts, etc.), so... if I type "6" into the [Points Awarded] column, it would generate "1st" in the [Placing] column.

I can't think of anything else, but if you can answer any of these questions, or want to point out anything strange I might have in my tables, feel free; I'll be grateful.
RubaiyateBandit is offline  
Sponsored Links
post #2 of 2 Old 09-02-2010, 06:13 AM
Join Date: Nov 2009
Posts: 5,289
• Horses: 0
Not sure about # 1, but I know 2 and 3 can be done.

I think the way to solve number 2 is to make separate tables with the class list for each type of show. If you're using a GUI or a dressed up Access form to make your new entries, you'd select the show type in one drop down and then only those classes would show in the next drop down.

3 is definitely possible too, the simplest way might be to put a little lookup table in your table list, and add the "Placing" field from your lookup table into your query. You could also write a formula or some VBA code with a list of If/then statement, but I think the first way is easiet.

Have no idea if that was any help.
maura is offline  

Quick Reply

Register Now

In order to be able to post messages on the The Horse Forum forums, you must first register.

Already have a Horse Forum account?
Members are allowed only one account per person at the Horse Forum, so if you've made an account here in the past you'll need to continue using that account. Please do not create a new account or you may lose access to the Horse Forum. If you need help recovering your existing account, please Contact Us. We'll be glad to help!

New to the Horse Forum?
Please choose a username you will be satisfied with using for the duration of your membership at the Horse Forum. We do not change members' usernames upon request because that would make it difficult for everyone to keep track of who is who on the forum. For that reason, please do not incorporate your horse's name into your username so that you are not stuck with a username related to a horse you may no longer have some day, or use any other username you may no longer identify with or care for in the future.

User Name:
Please enter a password for your user account. Note that passwords are case-sensitive.


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:


Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.

Old Thread Warning
This thread is more than 90 days old. When a thread is this old, it is often better to start a new thread rather than post to it. However, If you feel you have something of value to add to this particular thread, you can do so by checking the box below before submitting your post.

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page

Similar Threads
Thread Thread Starter Forum Replies Last Post
Carrot Locator Access Joshie Horse Forum Support Help Desk 23 01-09-2009 10:07 AM
Does anyone have access to the ASHA database? kickshaw Horse Breeds 6 05-23-2008 07:59 AM

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

For the best viewing experience please update your browser to Google Chrome