Find Jobs
Hire Freelancers

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

$50 AUD

Completato
Pubblicato più di 6 anni fa

$50 AUD

Pagato al completamento
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 [login to view URL] Set rst = New [login to view URL] [login to view URL] VAR_TABLE & " order by date ASC;", [login to view URL], adOpenStatic, adLockPessimistic If Not [login to view URL] Then '1st row VAR_NB_IN_ROW = 0 'VAR_TEAM_AWAY_PREV = rst("Away_team") VAR_AWAY_TEAM_WINLOSS_PREV = rst("AWAY_Team_WinLoss") rst("AWAY_Team_WinLoss_InRow") = FirstRow(rst("AWAY_Team_WinLoss"), VAR_HOME_AWAY) rst("AWAY_Team_nb_InRow") = 1 [login to view URL] Else 'MsgBox ("no data found with selected odds") [login to view URL] 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 [login to view URL]@[login to view URL] 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.
Rif. progetto: 15854941

Info sul progetto

8 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 giorni
4,6 (38 valutazioni)
6,0
6,0
8 freelance hanno fatto un'offerta media di $64 AUD
Avatar dell'utente
I just sent my email. I would like to work on your database. I have 16 years experience in Access.
$50 AUD in 1 giorno
4,9 (28 valutazioni)
5,5
5,5
Avatar dell'utente
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 in Microsoft Access and can deliver your with 100% quality.
$100 AUD in 2 giorni
4,9 (7 valutazioni)
4,4
4,4
Avatar dell'utente
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 Experience VBA Proposed Milestones $100 AUD - final payment
$100 AUD in 3 giorni
4,7 (4 valutazioni)
3,2
3,2
Avatar dell'utente
check your inbox. Relevant Skills and Experience check my profile Proposed Milestones $55 AUD - Prepaid (demo included)
$55 AUD in 1 giorno
5,0 (3 valutazioni)
1,8
1,8
Avatar dell'utente
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, and I am keen to continue developing my career in the field of data analysis, Access Database, SQL Server, and VBA programming.
$55 AUD in 1 giorno
5,0 (1 valutazione)
0,6
0,6
Avatar dell'utente
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 database management for MS Office businesses, and I am keen to continue developing my career in the field of data analysis, Access Database, Excel and VBA programming.   My expertise relies on: 1.         Solid knowledge of table/query design, form/report design, and automation utilizing VB modules. 2.         Expertise in debugging developed VBA codes and fixing them. 3.         Having Experience in Support Access and Excel application with SQL Server backend  4.         Experience in Identifying and understanding the requirements of the clients with respect to the database administration system that needs to be developed. 5.         Well versed with database concept and experience in using SQL statements for data validations.  6.         Have experience in developing Access databases and applications using VBA for data transformation and validation projects. 7.         Experience in design, automation, and solution development of various applications, including integrating existing user-developed Access databases into SQL server back-end and modifying front-end screens with professional UI interfaces. 8.         Developing data models and designing the database architecture as per the given instructions and modifying them to accommodate the system requirements. Installing several security features and granting access levels as per the user privileges set by the client to ensure maximum protection of the database system and avoiding theft of valuable data. 9.         Collecting data from various sources like QuickBook, Excel, MySQL, SQL, Azure and Manipulating, cleansing & processing data using Excel, Access, Macro, VBA, and SQL. 10.       Creating attractive and dynamic Reports in MS Access. 11.       Implementing Google Charts, Map into MS Access Forms, Reports (both offline and online).
$50 AUD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: AUSTRALIA
Churchlands, Australia
5,0
3
Metodo di pagamento verificato
Membro dal ago 4, 2016

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.