Find Jobs
Hire Freelancers

Microsoft Access - Betting System that requires fixing. (Loop on all Rows Programming)

$50 AUD

Terminado
Publicado hace más de 6 años

$50 AUD

Pagado a la entrega
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 a 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.
ID del proyecto: 15854923

Información sobre el proyecto

5 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, there I 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 en 10 días
4,7 (47 comentarios)
6,1
6,1
5 freelancers están ofertando un promedio de $53 AUD por este trabajo
Avatar del usuario
Hi.. having gone through your project details, I can help you in fixing issues you getting in Ms Access reports. I have worked on several such projects and completed well. Relevant Skills and Experience Technically well versed in handling MS Access projects and assure you of quick and efficient solution. Waiting for your response further. thanks. Proposed Milestones $50 AUD - project fee
$50 AUD en 2 días
4,8 (137 comentarios)
6,2
6,2
Avatar del usuario
Dear Mardam or Sir, You need an accountant . I am the one you need . I have great experience working as an Accounting throughout my career. I have over 10 years of experience and knowledge of accounting and good skill data entry, good at Office software and Xero, Myob, Quickbooks software all so. I will benefit you and your company if hired by you. I can deliver projects on time and to a high standard. I am ready to be hired by you now. Work plan: I will use 1 to 8 hours/day work for you with the most careful and correct accounting standards. Please hire me and contact me.
$50 AUD en 10 días
4,6 (7 comentarios)
3,8
3,8
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
Hi, I am interested to work on this Relevant Skills and Experience I am very good in excel/access-VBA. Proposed Milestones $55 AUD - Milestone 1
$55 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Churchlands, Australia
5,0
3
Forma de pago verificada
Miembro desde ago 4, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.