Find Jobs
Hire Freelancers

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

$50 AUD

已完成
已发布超过 6 年前

$50 AUD

货到付款
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.
项目 ID: 15854941

关于此项目

8提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在10天之内
4.6 (38条评论)
6.0
6.0
8威客以平均价$64 AUD来参与此工作竞价
用户头像
I just sent my email. I would like to work on your database. I have 16 years experience in Access.
$50 AUD 在1天之内
4.9 (28条评论)
5.5
5.5
用户头像
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 在2天之内
4.9 (7条评论)
4.4
4.4
用户头像
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 在3天之内
4.7 (4条评论)
3.2
3.2
用户头像
check your inbox. Relevant Skills and Experience check my profile Proposed Milestones $55 AUD - Prepaid (demo included)
$55 AUD 在1天之内
5.0 (3条评论)
1.8
1.8
用户头像
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 在1天之内
5.0 (1条评论)
0.6
0.6
用户头像
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 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

AUSTRALIA的国旗
Churchlands, Australia
5.0
3
付款方式已验证
会员自8月 4, 2016起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。