Thread: module
View Single Post
  #4  
Old 29th July 2003, 04:04 PM
Laurence Laurence is offline
Member
 
Join Date: Jan 1970
Posts: 12
Default

Hi

When you say specifications for the module what exactly do you mean.

For Victorian TAB the method is called Betsheet. They have the specifications in their Help section.

In summary you upload a tab delimited text file such as:
ADE G 9 WIN "1" $2.

In this example I would have had a win bet on number one in race nine for $2.00 at Adelaide greyhounds.

So you need a system to generate the text file and then you click the icon on the TAB site and the file is picked up and processed.

When you say specifications do you mean how to create the text file?

In Excel you could just key your data in the columns and save the file as text with a macro.

Alternatively, you could use MS Access to create a form for your data entry of combinations, with data validation so incorrect combinations and/or amounts were checked before being sent.

This form would write the bets to a table, you'd then extract the bets via a query and produce the text file using a bit of code like:

Sub makefile()
DoCmd.TransferText acExportDelim, , "qselMakeMyBets", "C:Monday.TXT"
End Sub

Note: You have to watch out for TAB race code changes. For example tonight Adelaide greyhounds are ADE G, they could just as easily be ADEL G tomorrow.

You could also write a standalone program to create your text file from your data entry - or if your bets are being "generated" via another system you may be able to link into it to exract the combinations and hence create the file.

Is this the sort of thing you wanted to know?

Laurence

[ This Message was edited by: Laurence on 2003-07-29 17:06 ]
Reply With Quote