Find Jobs
Hire Freelancers

Content Comparison function MS Access VBA

$30-250 CAD

Awarded
Posted about 9 years ago

$30-250 CAD

Paid on delivery
I have a MS Access database of Kits that contain multiple parts. I need a function to compare a selected kit to all others and find kits with Similar Content. Output list of all MKIT_id to Output_Tbl 1) Kit is Exact match parts and qty 2) Kit has all Same Parts, different Qty 3) Kit Contains all parts Master_Tbl 1) MKIT_Id (20 char) 2) Master_ Desc Detail_Tbl 1)MKIT_ID (20 Char) 2)Kit_Part_ID (20 char) 3)Kit_Part_Qty Output_tbl 1)MKIT_Id_Lookup 2)MKIT_Id_found 3)Match_Type (1, 2 or 3)
Project ID: 7377217

About the project

21 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $194 CAD for this job
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$95 CAD in 6 days
5.0 (301 reviews)
7.9
7.9
User Avatar
I have 15 years of experience as a software developer and consultant with specialties in programming and relational databases. I've worked for several employers through the freelancer website and have a proven record of providing quality workmanship. My experience and knowledge of coding and databases makes me one of your top bidders for this project. I take pride in my work and always strive to exceed customer expectations. I look forward to hearing from you and hope we can work in the near future. I'm available to start right away. Regards, Jerry
$194 CAD in 5 days
5.0 (30 reviews)
6.0
6.0
User Avatar
Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you need a function to compare a selected kit to all others and find kits with Similar Content. I can write a VBA function for your requirements. I have 6 year's experience designing and developing Microsoft Access Application. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio.
$55 CAD in 3 days
4.9 (70 reviews)
6.0
6.0
User Avatar
Hi I am interested in this project. I am an experienced MS Access developer. I can do the job for you. If interested in hiring me then please let me know so that we can discuss the scope, timelines and budget accordingly Thanks. Regards, Jawad
$55 CAD in 3 days
5.0 (79 reviews)
5.7
5.7
User Avatar
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. I have worked on lot of advance MS Access Projects and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$250 CAD in 3 days
5.0 (10 reviews)
5.4
5.4
User Avatar
Hi, expert here ready to start, pls share more details of the work, I assure you high quality work done. Thanks
$50 CAD in 3 days
5.0 (22 reviews)
5.3
5.3
User Avatar
A proposal has not yet been provided
$250 CAD in 20 days
5.0 (3 reviews)
4.2
4.2
User Avatar
Hello, I'm developing for my customers MS Access applications since mor than 25 years. This request is a very easy and cheap task. Can ypu pls. explain where you want to implement this function: in a report or inside a form or is a query started from a form required? If you want some screenshots of my previous project pls. let me know. Best regards, Paul Goldbeck
$40 CAD in 3 days
5.0 (5 reviews)
4.3
4.3
User Avatar
Hello, I’m newer to this freelancing website and am just beginning to build my online reputation and client base. Over the past 17 years, I’ve worked in a variety of functions spanning Information Technology, Supply Chain, Finance and Process Optimization with a key point of connectivity being my use of MS Access/Visual Basic to solve many of the problems presented in each role. I’ve built numerous applications varying from simple reporting tools to more complex multi-user client-server applications used in production environments. I am very motivated to exceed your expectations, earn a great review from you to post on the website, and begin a long standing business relationship. Your projects sounds interesting and I believe that my background will allow me to provide additional perspectives and insights into how to optimally leverage the data once we develop the base application. Developing the application that you’ve specified should be a straight forward exercise that I can complete quickly for you. After that, depending on what you're looking for, we can collaborate to take advantage of the rich functionality that Access presents. Please take a look at my resume information and feel free to reach out to me if you are interested in proceeding. If you choose to hire me, I promise you won’t be disappointed and I promise to go above and beyond for you. Thanks for your consideration, Rob
$100 CAD in 3 days
5.0 (6 reviews)
4.2
4.2
User Avatar
Dear Sir i can develop the require code in VBA to compare the various parts and create output files. Best Regards vnb400
$155 CAD in 3 days
5.0 (13 reviews)
3.9
3.9
User Avatar
Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$200 CAD in 3 days
4.9 (5 reviews)
3.2
3.2
User Avatar
Please review my profile I am working with skills that you required for this job from 14 years. Screenshots I have attached in zip file which has lots of samples of MS Access,Excel,MS SQL with VBA work I have done. I can definitely help you in this job, to make your database design very proficient. Recently I have done projects in Power Pivot,DAX with Excel. If you want to know my advanced level skills in MS Access/Excel with VBA, we will do a Skype or G-talk discussion. I will shows my advanced skills in MS Access/Excel via arrange demo via screen sharing session etc.
$277 CAD in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
Please share some sample data and your Exact requirement so that i can understand well do this task ASAP
$155 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$231 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than ten years of experience developing databases and programming on VBA. To develop this project I will create a VBA function with the selected kit ID as input parameter. This function will compare the parts and quantity of this kit against the Detail_Tbl data and it will determine in which of the three categories will fall. At this point, it will add the matches to the Output_tbl. I will deliver this project in 5 days for the price of US$188. For further details, please feel free to contact me.
$188 CAD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am top expert VBA coding for MS. Excel & Access 2010-2013, with data analysis and data mining strong knowledge for building graphs and statistical formulas; have own the badge (SQL LEVEL 3, for databases programming)
$155 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
7+ years in VBA, VbScript. Looking forward for long term relationship starts with small steps. Lets catch up. Ping.
$150 CAD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Canada
0.0
0
Member since Mar 26, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.