View Single Post
Old 02-07-2008, 10:34 AM   #38 (permalink)
falkonisback
Major Leagues
 
Join Date: Mar 2007
Posts: 407
Well, I don't know if Tysok would want me to distribute his utility..lol. I mean, I have a bunch of custom things that I did for my solo league.

For instance, I wrote a function that goes into the Players - shrunk table and removes those nasty quotation marks around the first and last names (I hated that).

I also wrote a function that digs through all the players' history files and finds the year in which they retired.

I have a function that updates whether or not a player is even eligible for the HOF after their 5 year waiting period is up (needs a certain amount of PA's or IP for pitchers to even show up..anything less than that, I'm just wasting my time looking through their stats).

I also made my own forms to view total career stats for hitters and pitchers (dressed it up a little) as well as a form to view year by year stats for hitters and pitchers.

I came across a little problem with one of my functions with some of the recordsets coming up empty b/c if a player never won a certain award, the field would be null..I wrote a function to fill those NULLs with 0's to make it easier to work with.

I also made a separate form for hitters and pitchers that doesn't have any records at all in the awards table just for them b/c I list the total of each award that the player has won and if it didn't find any record in the awards table, the form would come up blank.

But as for me to distribute it, that would totally be up to Tysok..I mean he is the man who made the program and came up with the idea, all I did was customize it a little to my needs. But if he gives permission, I don't have a problem uploading it. On the career stats form, I do have a lable that comes up if that player is in the HOF that says 'LSBL Hall of Famer'...you might want to change that to match your own league..lol
__________________
GM of the OBL - Cincinnati Reds (578-654, .469)
1938 NL West Champs
1938 National League Champs

GM of the SSBL - Atlanta Braves (360-254, .586)
2022, 2024-2025 NL East Champs
2024 National League Champs

GM of the BJHL - Avery Island Hot Peppers (235-251, .484)

Last edited by falkonisback : 02-07-2008 at 10:38 AM.
falkonisback is offline   Reply With Quote