My round of golf

Posted on 2005-05-08
Last Modified: 2008-03-03
I’m creating a golf score db to keep track of my rounds of golf. I have these tables:

tblCourseInfo            general course info(name, address, phoe, etc)
tblCourseHoleDetail                      detailed hole information for the golf courses(hole number, par, distance, etc.)
tblGolfer                                      Golfer information(name, address phone, etc.)
tblRound                                      holds(roundid, date, courseid, golferid)
tblRoundDetail                      holds score details(hole score, # putts, Green in reglation, etc)

My problem is how to update the tblRoundDetail with the information entered in the form. I know this can be accomplished easier if I use datasheet or continuous form for a sub form, but I want to create a form that resembles the golf score card.
This the way I would like the form to work.
1.      select golfer from combobox
2.      select course from combobox (this would update unbound controls with records  related to the golf course holes on the table- par rating, hole distance, etc.
3.      enter date
4.      then enter score details

I'm doing this in access 2003

Thanks in advance
Question by:4isteam
    LVL 65

    Accepted Solution

    Hi 4isteam,

    > I want to create a form that resembles the golf score card.
    You can still do this, but instead of holes 1, 2, 3... going from left to right, you'll need this from up-to-down, and after you select golfer-course-date run an APPEND query that adds 18 records for holes 1-18 for this golfer-course-date, sort them ascending by hole, and make these new records the .RecordSource of your subform.

    Hope this helps.

    Author Comment

    thanks for your response jimhorn,
    I know its easier to do it putting the holes up to down but thats not how a golf score card goes and thats what i'm trying to accomplish if possible.
    LVL 65

    Expert Comment

    by:Jim Horn
    Good luck. (read:  I don't know how you can do this)  Perhaps Crystal Reports?
    LVL 8

    Assisted Solution

    Every golf score card Ive ever seen has had holes 1 to 9 down one side and 10 to 18 down the other, with totals boxes at the bottom of each column. You could either have one subform displaying all the holes and scrolling function to allow you to see all records, or put two subforms on the form, on for the first 9 and one for the second. To select golfer and course information and have it displayed on the form you will have to have the embedded subform/s in the main form, with the golfer and course combo or list boxes on the main form.
    Another option if you dont want to use subforms is to use frames on the mainform.
    This is fairly simple and standard form design though, so you shouldnt have too many probs there.

    LVL 8

    Expert Comment

    Sounds fair.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now