Find Jobs
Hire Freelancers

Build me an Access Database VBA Code

$30-250 USD

已完成
已发布大约 4 年前

$30-250 USD

货到付款
I have already built the Access database. I just need a VBA code to make it do the main function it was built for. It has a dashboard that displays the results as the VBA code is run. There is a textbox on which the user will type in some words and some sentences. The purpose of the VBA is to run a dynamic search that yields results for at least 80% matches. The main data source is a table and associated query which contain two of the columns from which the matches are to be made as the user inputs the search data. The table currently has over 3,000 records. As the user types in the search words or sentences, the number of matches found should be decreasing since we are looking for at least 80% matches per record. We also need to be able to add a column to the query that displays the matching percentage per record. The VBA code must be customizable so I can finish the work myself. I simply need the code to be able to execute the basic dynamic searching and matching functions of the database with the minimum required matching percentage. This is where I'm having some challenges. I can pretty much handle the rest.
项目 ID: 24818284

关于此项目

27提案
远程项目
活跃4 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi, Keen to work on this project. I have recently completed MS Access based project with good feedback. I am well versed with MS Access VBA. https://www.freelancer.com/projects/microsoft-access/Make-Microsoft-Access-Database-Process/reviews https://www.freelancer.com/projects/microsoft-access/Access-simple-CMR/reviews Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010,2013,2019 projects both big and small using MS Access as a front end as well as back end. I have worked on Forms, Queries, Modules, Reports, Sub Reports, Macros, Switch Board Manager, Linked Table Manager etc. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$125 USD 在3天之内
4.9 (216条评论)
6.9
6.9
用户头像
Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of course, familiar. Regards, Vladimir
$50 USD 在1天之内
4.9 (265条评论)
7.2
7.2
27威客以平均价$139 USD来参与此工作竞价
用户头像
Hi, there! My name is Paris, and I was glad to see that you're looking for an Access developer. According to your brief, you want to have some VBA code in your database to let you return results based on 80% of what is typed in a search box while making this percentage dynamic. I will charge you $120* and can deliver within a couple of days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Access and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed nearly 400 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$120 USD 在2天之内
5.0 (541条评论)
8.5
8.5
用户头像
Hello, I can help you with your project - Build me an Access Database VBA Code I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$240 USD 在5天之内
4.9 (423条评论)
8.3
8.3
用户头像
Hi. I am ready to write your project. I have written many automation VBA macros also database projects. Will complete within 5 days
$190 USD 在5天之内
4.9 (247条评论)
6.7
6.7
用户头像
Hi I hope all is well with you. I'm professional and very experienced ms access/vba developer . Please, see my portfolio here. I'll code vba modules combined with queries, if need I'll use sql/ado coding etc, search process will be dynamical etc All modules will be acceptable for you. We can discuss about price and delivery time. Regards, Zurab
$222 USD 在3天之内
4.8 (82条评论)
6.5
6.5
用户头像
You could send screen prints and table prints with explanations of how it works: What is working and what is missing. If possible, send the Access database as a compressed file. I am a specialist in Microsoft Access with Visual Basic for Applications and I am also a Mathematician.
$140 USD 在7天之内
4.9 (15条评论)
6.1
6.1
用户头像
Hi. Hope you're well. I was reading your project and it has left me a bit intrigued. I'm an Access and VBA expert, but I don't fully understand what you really need. First, assuming that the two columns are of Long Text type, when searching in Tables or Queries, the matching operators return the 100% match. Even if you use the Like operator that searches for part of a string in a column. So I don't understand when you say you want to achieve 80% match on each record? Can you share an example of the information returned by the two columns and the possible text that the user will enter? The project is interesting and I would like to help you but to estimate the price and time and to clarify the requirement. If you want, Let me know and let's talk about it. About me, I am an Systems engineer, Desktop Apps Programmer with Microsoft technology, an Excel - VBA Macro expert and web scraping enthusiast, you can see my achievements in my profile. However, I have learned in the last 15 years of experience as a developer that it is more important to understand the business model, the needs and objectives of my clients than the tools required. So, I would like to help in your project I will start right now and I will do it before your time . Daniel
$50 USD 在2天之内
5.0 (33条评论)
5.2
5.2
用户头像
I have a generic search form available which provides a search-as-you-type experience not available as standard within Access. This would suit you application very well and I would be happy to demonstrate it to you. I use dynamic SQL in VBA to search for data as a standard technique in all of my Access applications and would certainly be able to handle your requirements. I have over 20 years experience developing applications in Access, with particular skills in integration with Excel, Word and Outlook. I have a number of clients who have come to me with an existing system which needs modification or maintenance. I take a flexible approach ranging from giving tuition to users who want a maintain a DIY approach to a total adoption of the system and responsibility for all changes and maintenance. I have several clients in Canada and the USA, including California, Texas, Vancouver and Montreal. The remote relationship I forge with my US clients works very well. We interact via email, telephone and TeamViewer. My working day overlaps with your mornings, and I work flexible hours so I can manage meetings later in your working day. Please call me on +44 292 125 8848 to discuss your requirement in more detail. I am available from 09:00 to 19:00 BST / 01:00 to 11:00 PDT/ 04:00 to 14:00 EDT Or message me with more detail or if you have questions. Kind regards Neil Sargent Please note: I have bid a guide price which may change once a detailed specification has been agreed.
$250 USD 在7天之内
5.0 (7条评论)
4.9
4.9
用户头像
Hi there, I can write VBA code to search in the table as the user starts typing in the textbox. I need some clarification about matching percentage. Please send me a message to discuss further, if you like. Looking forward.
$30 USD 在2天之内
5.0 (13条评论)
5.0
5.0
用户头像
-- 20 years MS Access VBA Expert --- I read your requirements ... i can fulfill your requirement 100% .......
$100 USD 在7天之内
4.9 (13条评论)
4.5
4.5
用户头像
Hello ⭐⭐⭐ please see my portfolios in ms office programming & vba in my profile i'm developer with +12 years experience & expert in ms access, ms excel, vba macro, design databases & reporting i'm so interested to work with you in this project warmest regards
$250 USD 在10天之内
5.0 (9条评论)
4.3
4.3
用户头像
Hi, I am ready to help you in your access db vba. I have experience in MS SQL server,asp.net, crystal reports and VB.net more than 12 years. also i am good in access vba, excel vba. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - University of Syria-Aleppo - year 2006. Programming and database specialized, expert in vb.net and SQL server with all versions, Crystal reports, also expert in iis and Windows servers 2005, 2008, 2012… Other skills: C#,asp.net, Php, my sql , technical & Sage ACCPAC ERP support, SQL Replication, Excel vba and macros, Access vba, Microsoft office(Word, Excel, PowerPoint, Access). Best Regards. Khaled Alflah
$240 USD 在7天之内
4.9 (15条评论)
4.1
4.1
用户头像
Hi, the job is basically to write 1 or 2 vba event handlers, and within the code the right sql query/ies. I'm expert with access and vba with more than 20 years of experience. Let's chat, share the desktop session and get it done. best regards Esteban Salpeter
$60 USD 在1天之内
5.0 (9条评论)
4.2
4.2
用户头像
Hi,dear! I am quite interested in your project - 'Build me an Access Database VBA Code'. :) I've already done this kind of project before. I am a skillful software developer who has rich experience in this field. If you contact me, you and I will be happy. Thank you in advance. Skills: Data Processing, Microsoft Access, Visual Basic, Visual Basic for Apps
$155 USD 在1天之内
5.0 (7条评论)
3.0
3.0
用户头像
I am a systems analyst with more than 7 years of experience in the management of Access databases and Excel datasheets in a multi-national company. Advanced level competence in data analisys for decision making and great knowledge of all Office tools. Design of databases, forms, querys, macros, reports, etc. I am available now, send me a text message and I will answer asap.
$110 USD 在5天之内
5.0 (4条评论)
2.9
2.9
用户头像
Hi, I am an expert developer in VBA and MS Access and can deliver your project requirements in day with best quality.
$30 USD 在1天之内
5.0 (2条评论)
1.7
1.7
用户头像
Hello, I read your project description and understand all. I have 20 years in Database development, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, C# and MS SQL server I will make the perfect product what you want. I promise to complete your project within your time and budget beyond your expectations. I am willing to work at lower pay. Let me know when we can discuss and share all.
$49 USD 在7天之内
5.0 (2条评论)
1.5
1.5
用户头像
I hearby willing to accomplish any task given to me. I will do all my work on to.e and also submit it on time with my quality experience I am having Relevant Skills and Experience I have been working for so many years do this work. I have a lot of experience in data base. Having me will be great pleasure because of my experience
$156 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
I do have such code in Visual Basic 6 which searches as you types. I can give you the source code of the same which you can add in your software or I can do the same
$250 USD 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
HAPPY TO HELP WITH YOUR JOB I am confident in your project and I can finish it clearly on time. I am well experienced and skillful VBA, Excel, Access I ensure the best quality of your project and to keep your deadline. Please contact me kindly and let us discuss in more detail. Working with me, you will have a good experience and good friends. I would be glad working with you! Sincerely.
$140 USD 在7天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi My name is Clive Townsend. I am a Chartered Accountant working in Johannesburg. I am an expert in Excel and Access vba. I can easily write this code for you and give you further support should you so require. Kind regards Clive
$150 USD 在7天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Stafford, United States
4.2
1
付款方式已验证
会员自4月 9, 2020起

客户认证

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