If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
calculate values in a form
FREE data model to set up a golf database:
http://www.databasedev.co.uk/golf_club_data_model.html FREE discussion on calculating handicaps: http://groups.google.com/group/comp....4386112aa56027 FREE Golf Tournament example by John Viescas: http://www.viescas.com/Info/links.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "Distressed Golfer" Distressed wrote in message ... We are doing a handicap register for a golf club and really need some help about how to calculate the handicap. The formula we want touse is for each round the difference between the actual score and the par value with a maximum of 2 per hole and then take the average of three rounds. A further complication is we want the max handicap for a women or junior to be 36 and just 28 for a man. We are really totally lost how to do this. This is our first ever database. |
#12
|
|||
|
|||
calculate values in a form
"Steve" wrote:
You missed giving the OP another piece of your "Free Advise"; you didn't tell him that he should use object names that are 50+ characters long!! Let go of your anger at being told you were wrong, you're letting it make an idiot of you! What anger? Was I supposed to be angry? Where was I wrong? I've completely forgotten. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
#13
|
|||
|
|||
calculate values in a form
"Steve" wrote:
BTW, the last idiot that responded uses 50+ characters for field names, table names, query names, form names and report names and thinks that is cool!!! He is probably very sad his own name is so short!!! chuckle Very occasionally I will use table, query, form and report names that are 50+ characters long. Not, to my knowledge, field names. However when you're dealing in an app with 160 tables, 1200 queries, 450 forms, 350 reports and 70,000 lines of code sometimes you have to get a bit wordy. The relationships diagram is the full 4' width of the relationships window and about 3' tall. Stephen Lebans had to make me a special utility to stitch the relationships windows together just so we could print it. The maximum report size is 22" x 22", IIRC, and that was way too small. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
#14
|
|||
|
|||
calculate values in a form
"Gina Whipp" wrote:
FREE data model to set up a golf database: http://www.databasedev.co.uk/golf_club_data_model.html FREE discussion on calculating handicaps: http://groups.google.com/group/comp....4386112aa56027 FREE Golf Tournament example by John Viescas: http://www.viescas.com/Info/links.htm chuckle Gotta love that word free, free, free. Thanks, Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
#15
|
|||
|
|||
calculate values in a form
8-)
-- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "Tony Toews [MVP]" wrote in message ... "Gina Whipp" wrote: FREE data model to set up a golf database: http://www.databasedev.co.uk/golf_club_data_model.html FREE discussion on calculating handicaps: http://groups.google.com/group/comp....4386112aa56027 FREE Golf Tournament example by John Viescas: http://www.viescas.com/Info/links.htm chuckle Gotta love that word free, free, free. Thanks, Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
#16
|
|||
|
|||
calculate values in a form
"Steve" wrote:
This is a great example of the "free support" you preach about!!! You have demonstrated that the reason it is free is that it "ain't worth a tinker's damn"!! You missed giving the OP another piece of your "Free Advise"; you didn't tell him that he should use object names that are 50+ characters long!! Let go of your anger at being told you were wrong, you're letting it make an idiot of you! All that and no response to your central problem with you Steve. Why are you trolling for customers against the rules? Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
#17
|
|||
|
|||
calculate values in a form
"Tony Toews [MVP]" wrote:
All that and no response to your central problem with you Steve. Why are you trolling for customers against the rules? All that and no response to our central problem with you Steve. Why are you trolling for customers against the rules? Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
#18
|
|||
|
|||
[OT] calculate values in a form
Dear Tony:
The relationships diagram is the full 4' width of the relationships window and about 3' tall. Stephen Lebans had to make me a special utility to stitch the relationships windows together just so we could print it. The maximum report size is 22" x 22", IIRC, and that was way too small. If you ask me, that *has* to qualify as some kind of art! One day, when I create my "Access Lair" in the basement, I'm going to ask you for a signed copy of that printout, and frame it for hanging! g Cheers! -- Fred Boer - Amateur Access Enthusiast Interests: Library software / Z39.50 / Web Services Freeware Small Library Application available he http://www3.sympatico.ca/lornarourke/ |
#19
|
|||
|
|||
[OT] calculate values in a form
"Fred Boer" wrote:
The relationships diagram is the full 4' width of the relationships window and about 3' tall. Stephen Lebans had to make me a special utility to stitch the relationships windows together just so we could print it. The maximum report size is 22" x 22", IIRC, and that was way too small. If you ask me, that *has* to qualify as some kind of art! I've heard of two systems a bit larger, one that had 220 tables. One day, when I create my "Access Lair" in the basement, I'm going to ask you for a signed copy of that printout, and frame it for hanging! g Sure, but I'll have to find a plotter to print it on. I fired that client a while back due to a new *rsehole manager type who thought he knew something about software so I don't have access to a plotter any more. BTW I'm told by some MS folks that the relationships diagram was hanging in a hallway at Microsoft for six months or a year. Folks would walk by and say "That was done in Access?!!?!" Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ |
#20
|
|||
|
|||
calculate values in a form
"Steve" schreef in bericht ... Dear Distressed Golfer, Please ignore the idiots that responded to your post!! It is always nice when you make these jokes... I appreciate a good laugh in the morning... Thanks !! You were the first responder, ha,ha,ha,ha But you ALWAYS forget to look at yourself don't you ?? Arno R |
Thread Tools | |
Display Modes | |
|
|