lwto
Hall of Fame
Hello all, I have been working on a stringing program that is designed to keep track of any type of racquet services rendered. So over the last month or so, and with the exception of a few minor issues, I think it is ready for some public critique. I’m hoping those of you that have MS Access 2007 or above would give it a quick look and give me some of your thoughts as to what could be better, what needs to be added, or subtracted.
This is a very simple program, yet has the potential to really aide the stringer in keeping track of their clients, client racquets, string jobs, Racquet services and history. For example It will Keep track of your client base. Keep track of your clients racquets, including history, specs any open orders etc, keep track of racquet modifications. It has a lookup, editable stringing pattern database for tennis racquets only right now, but in later versions I will include badminton and racquetball racquets. AT a glance you can see how many jobs you have done, how many jobs done for a particular client and how many jobs done on a particular racquet.
It is fast, In fact, probably faster than writing a label out.
Has a self generating label for the brother p touch printer at ½ inch. I find the ¾ inch label to bulky and cumbersome.
Creates your own business cards.
So if you are interested, in just checking this out, I do encourage you to do so.
Again, this is work in progress, but I think looks pretty good so far, there is still I have on the plate to add such as multiple stringing machines, Multiple stringers, accounting and some other items.
I won’t bore you with how to work it, it is pretty easy to figure out, just for now.. fill out the Admin info to get your opening screen right.. defaulted to something else right now. If you don’t and you try to print labels it will come out with the default stringing company name.
I don’t have stringing itemized.. for instance in the open work order where you put in service detail.. you would put in the string job. So it would be like this..
M, Babolat Pro Hurricane 18@48lbs
X, Forten Sweet 17@52lbs.
When you put in the first line, you need a CARRAIGE RETURN for the 2nd line.. you do that by using the shift key. [shift][enter] That will give you a line break. It is important because when you print your label, it will go straight through with out a line break.
This is configured for the Brother Ptouch ¾ printer, but the label is setup for the ½ tape. The ¾ I found just to bulky and just didn’t look as good.
Another tip, is that if you just want to add the job, without doing the job..Put the status on Working.. and when you go back.. just over write the Service Detail info with the new info.
You will all figure it out, if you have any questions, just let me know, I’ll answer them via the forum or email if you email me.
I'd like to attach the program, but do not seem to be able to so If you would like to try it, email me at blabolat@gmail.com
I have some pics too.. this is the opening screen you will see with the outstanding service orders.. links to other parts of the program.
clicking on MAIN will give you this screen.
This is just a list of your clients that you have.. you open one to get the details. such as this screen shot of the details of your client.
From here you can see the details.. the service overview of all the work you have done for that person. and you can tab over to get the Racquet details..
That is where you will do the bulk of the work.. Service orders, adding racquets etc. You can see the pull down list to all easy selection of your racquet.. or their racquet.
too continue on the next post.. 4 images is the limit.
This is a very simple program, yet has the potential to really aide the stringer in keeping track of their clients, client racquets, string jobs, Racquet services and history. For example It will Keep track of your client base. Keep track of your clients racquets, including history, specs any open orders etc, keep track of racquet modifications. It has a lookup, editable stringing pattern database for tennis racquets only right now, but in later versions I will include badminton and racquetball racquets. AT a glance you can see how many jobs you have done, how many jobs done for a particular client and how many jobs done on a particular racquet.
It is fast, In fact, probably faster than writing a label out.
Has a self generating label for the brother p touch printer at ½ inch. I find the ¾ inch label to bulky and cumbersome.
Creates your own business cards.
So if you are interested, in just checking this out, I do encourage you to do so.
Again, this is work in progress, but I think looks pretty good so far, there is still I have on the plate to add such as multiple stringing machines, Multiple stringers, accounting and some other items.
I won’t bore you with how to work it, it is pretty easy to figure out, just for now.. fill out the Admin info to get your opening screen right.. defaulted to something else right now. If you don’t and you try to print labels it will come out with the default stringing company name.
I don’t have stringing itemized.. for instance in the open work order where you put in service detail.. you would put in the string job. So it would be like this..
M, Babolat Pro Hurricane 18@48lbs
X, Forten Sweet 17@52lbs.
When you put in the first line, you need a CARRAIGE RETURN for the 2nd line.. you do that by using the shift key. [shift][enter] That will give you a line break. It is important because when you print your label, it will go straight through with out a line break.
This is configured for the Brother Ptouch ¾ printer, but the label is setup for the ½ tape. The ¾ I found just to bulky and just didn’t look as good.
Another tip, is that if you just want to add the job, without doing the job..Put the status on Working.. and when you go back.. just over write the Service Detail info with the new info.
You will all figure it out, if you have any questions, just let me know, I’ll answer them via the forum or email if you email me.
I'd like to attach the program, but do not seem to be able to so If you would like to try it, email me at blabolat@gmail.com
I have some pics too.. this is the opening screen you will see with the outstanding service orders.. links to other parts of the program.
clicking on MAIN will give you this screen.
This is just a list of your clients that you have.. you open one to get the details. such as this screen shot of the details of your client.
From here you can see the details.. the service overview of all the work you have done for that person. and you can tab over to get the Racquet details..
That is where you will do the bulk of the work.. Service orders, adding racquets etc. You can see the pull down list to all easy selection of your racquet.. or their racquet.
too continue on the next post.. 4 images is the limit.
Last edited:
