Microsoft Access - Betting System that requires fixing. (Loop on all Rows Programming) - 12/12/2017 01:03 EST

The main component of the Access betting system is complete. The design, input and the reports are complete. The problem I have are at times, the computer seems to have a mind of its own as the results are sometimes incorrect. For example, in a very simple way of explaining it, if I click on an activation button to provide the report, and then do it again without touching the input, I would sometimes get a different outcome. For example, if the input for line 1 is 100 and line 2 is 200, the report shows total 300. If I redo the report again right away, sometimes the report would be 400.

The Primary Report is the actual sequence of wins / losses in a row. The Secondary Report is derived from the Primary Report based on the last outcome of match.

I would like a guru Microsoft Access Programmer to look at the programming component, fix the 5 Reports so the outcome is always 100% correct, not 95% correct. (Need to fix the errors from the Primary Report, Secondary Report, Both Team Report, Both Team Secondary Report and Report 2). They are all looped with other filters Home Team, Ground, Round.

A taste of the programming.

Function Calcul_WinLossInRow(VAR_TABLE, VAR_HOME_AWAY)

Dim rst As [url removed, login to view]

Set rst = New [url removed, login to view]

[url removed, login to view] VAR_TABLE & " order by date ASC;", [url removed, login to view], adOpenStatic, adLockPessimistic

If Not [url removed, login to view] Then

'1st row


'VAR_TEAM_AWAY_PREV = rst("Away_team")


rst("AWAY_Team_WinLoss_InRow") = FirstRow(rst("AWAY_Team_WinLoss"), VAR_HOME_AWAY)

rst("AWAY_Team_nb_InRow") = 1

[url removed, login to view]


'MsgBox ("no data found with selected odds")

[url removed, login to view]

Set rst = Nothing

Exit Function

End If

'Loop on ALL rows

While Not rst.EOF.





So if you don't understand this, please don't reply.

If you are a guru Access Programmer who is interested, please provide your email address details to my email address [url removed, login to view]@[url removed, login to view] saying that you are interested of fixing it so that l can forward to you the Access program in due time so I can explain it in detail to you so that you can understand the betting methodology. To be fair, I will issue the emails to all interested programmers at the same time. The first one to send back to me with the modified Access program into my inbox that does exactly what I want with no issues will be paid $50 AUD.

My betting system is based around with filters Home Teams, Away Teams, Both Teams, Home Odds, Away Odds, Date, Ground, Win or Loss in a row, outcome. It is based on sequential date order. (I would prefer a new column added to the fixture called sequence "Seq" as in numerical sequence and have the loop around the numerical sequence instead of "Date" sequence order).

I will forward an email to you as a reminder of when I will be releasing the Access File. This way everyone will have the same starting time. The first one to forward back to me in my inbox the correct updated version will get $50 AUD.

And maybe that winner will have future works with me for future add on to the program.

Good Luck.

Evner: Microsoft Access

Se mere: access betting system, microsoft access mrp system, microsoft access filing system, sql, microsoft access tracking system, microsoft access ticketing system, microsoft access booking system design, microsoft access contract system template, microsoft access rental system, sample inventory system microsoft access, airline reservation system using microsoft access database, sample inventory system using microsoft access vbnet programming, clocking card machine system microsoft access, billing system microsoft access, microsoft access lending system, system time microsoft access

Om arbejdsgiveren:
( 3 bedømmelser ) Churchlands, Australia

Projekt ID: #15854941

Tildelt til:


Hi, I've emailed to you. Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office 97 released Proposed Milestones $55 AUD - default

$55 AUD in 10 dage
(38 bedømmelser)

8 freelancere byder i gennemsnit $64 på dette job


I just sent my email. I would like to work on your database. I have 16 years experience in Access.

$50 AUD på 1 dag
(28 bedømmelser)

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. Ship Fuel Oil & Wate Flere

$50 AUD in 2 dage
(35 bedømmelser)

Greetings, I can help you in Microsoft Access. Please ping me for more discussion. Please see my profile i have deliver almost 280 projects with 100% client satisfaction. I have more than 5 years of experience Flere

$100 AUD in 2 dage
(7 bedømmelser)

I am not a random bidder.. I hope I can help on this one.. Could you please share the Access file and provide more details.. Please ping me if you are interested with my proposal and Thank you.. Relevant Skills and Ex Flere

$100 AUD in 3 dage
(4 bedømmelser)

check your inbox. Relevant Skills and Experience check my profile Proposed Milestones $55 AUD - Prepaid (demo included)

$55 AUD på 1 dag
(3 bedømmelser)

My name is Rayyan. I work as a full-time MS Access Programmer. I have spent the past 10+ years doing full automation, building custom applications, number crunching, and database management for MS Office businesses, an Flere

$55 AUD på 1 dag
(1 bedømmelse)

Its very simple. I can fix it easily. about me: My name is Deepak. I work as a full-time MS Access Programmer. I have spent the past 4+ years doing full automation, building custom applications, number crunching, and Flere

$50 AUD på 1 dag
(0 bedømmelser)