Find Jobs
Hire Freelancers

Build me an Access Database VBA Code

$30-250 USD

Terminado
Publicado hace alrededor de 4 años

$30-250 USD

Pagado a la entrega
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 del proyecto: 24818284

Información sobre el proyecto

27 propuestas
Proyecto remoto
Activo hace 4 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, 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 en 3 días
4,9 (216 comentarios)
6,9
6,9
Avatar del usuario
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 en 1 día
4,9 (265 comentarios)
7,2
7,2
27 freelancers están ofertando un promedio de $139 USD por este trabajo
Avatar del usuario
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 en 2 días
5,0 (541 comentarios)
8,5
8,5
Avatar del usuario
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 en 5 días
4,9 (423 comentarios)
8,3
8,3
Avatar del usuario
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 en 5 días
4,9 (247 comentarios)
6,7
6,7
Avatar del usuario
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 en 3 días
4,8 (82 comentarios)
6,5
6,5
Avatar del usuario
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 en 7 días
4,9 (15 comentarios)
6,1
6,1
Avatar del usuario
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 en 2 días
5,0 (33 comentarios)
5,2
5,2
Avatar del usuario
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 en 7 días
5,0 (7 comentarios)
4,9
4,9
Avatar del usuario
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 en 2 días
5,0 (13 comentarios)
5,0
5,0
Avatar del usuario
-- 20 years MS Access VBA Expert --- I read your requirements ... i can fulfill your requirement 100% .......
$100 USD en 7 días
4,9 (13 comentarios)
4,5
4,5
Avatar del usuario
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 en 10 días
5,0 (9 comentarios)
4,3
4,3
Avatar del usuario
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 en 7 días
4,9 (15 comentarios)
4,1
4,1
Avatar del usuario
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 en 1 día
5,0 (9 comentarios)
4,2
4,2
Avatar del usuario
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 en 1 día
5,0 (7 comentarios)
3,0
3,0
Avatar del usuario
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 en 5 días
5,0 (4 comentarios)
2,9
2,9
Avatar del usuario
Hi, I am an expert developer in VBA and MS Access and can deliver your project requirements in day with best quality.
$30 USD en 1 día
5,0 (2 comentarios)
1,7
1,7
Avatar del usuario
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 en 7 días
5,0 (2 comentarios)
1,5
1,5
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Stafford, United States
4,2
1
Forma de pago verificada
Miembro desde abr 9, 2020

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.