Karaoke Scene's Karaoke Forums
https://mail.karaokescenemagazine.net/forums/

Does anyone know MS Access?
https://mail.karaokescenemagazine.net/forums/viewtopic.php?f=1&t=17776
Page 1 of 1

Author:  diafel [ Thu Sep 17, 2009 8:27 am ]
Post subject:  Does anyone know MS Access?

This has nothing to do with Karaoke, but I thought I'd ask here since everyone here is so helpful.
I run our local pool (billiards) league and we currently run with a standard handicapping system, which means the most any player can get in points is 10, 1 for each ball down, but 3 for the 8. The losing player can get 7 at most.
We want to move to a handicapping system of 17. This will mean that the winner will not only get the 10 for winning, but also one point for each of the opponent's balls they have down. The loser's available points will remain at 7.
Here's the problem.
We run our stats program with MS Access 2003.
The program is designed to avoid mistakes and will not let me enter more than 10 for the winner. I barely know how to run the program as it stands, and definitely don't know how to change the formula for the points.
The writer of the program left the league long ago and is no longer available to help.
Can anyone help me?
I'd be more than willing to send the .mdb file if it will help.
Thanks in advance.
Cheers!

Author:  Foxe [ Thu Sep 17, 2009 12:43 pm ]
Post subject:  Re: Does anyone know MS Access?

I think I can help you out.. you can send me the .mdb file

cschick90 at hotmail dot com

Author:  jdmeister [ Thu Sep 17, 2009 3:14 pm ]
Post subject:  Re: Does anyone know MS Access?

Yes, send it to ^^ .. :mrgreen:

Author:  diafel [ Thu Sep 17, 2009 4:04 pm ]
Post subject:  Re: Does anyone know MS Access?

Thanks! I've sent it and I really do appreciate it.
Cheers!

Author:  eben [ Thu Sep 17, 2009 9:47 pm ]
Post subject:  Re: Does anyone know MS Access?

Foxe @ Thu Sep 17, 2009 12:43 pm wrote:
I think I can help you out.. you can send me the .mdb file

cschick90 at hotmail dot com


Wow, a woman who can sing and do DB. Someone after my own heart. :mrgreen:

Author:  Foxe [ Fri Sep 18, 2009 6:45 am ]
Post subject:  Re: Does anyone know MS Access?

eben @ Thu Sep 17, 2009 11:47 pm wrote:
Foxe @ Thu Sep 17, 2009 12:43 pm wrote:
I think I can help you out.. you can send me the .mdb file

cschick90 at hotmail dot com


Wow, a woman who can sing and do DB. Someone after my own heart. :mrgreen:


lol just goes to show I still have a few tricks up my sleeve ;)

Diafel, I got your email - please check for my reply.. thanks ;)

Author:  diafel [ Sat Sep 19, 2009 8:23 am ]
Post subject:  Re: Does anyone know MS Access?

Foxe:
I can't thank you enough. You have changed our league for the better. It has to be the single best change since the league started 12 years ago. I can't stress enough how grateful I am to you for your help. And fast, too!
I am truly amazed.
Just wish I knew how to do it it myself :? :| I just may have to start learning it.
Cheers!

Author:  Foxe [ Sun Sep 20, 2009 8:39 am ]
Post subject:  Re: Does anyone know MS Access?

you're more than welcome :) I enjoyed helping you out :) and now even I'm excited for your season LOL.

As far as learning it..

I found the book I started off with learning Access on.. it's
Microsoft® Office Access 2003 Step by Step (Step By Step (Microsoft))

You might be able to pick it up cheap somewhere and maybe that will help give some basics if you're interested.

good luck! :)

Page 1 of 1 All times are UTC - 8 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/