Find Jobs
Hire Freelancers

I would like to hire a Microsoft Access Developer

$30-250 CAD

Dokončeno
Zveřejněno před více než 5 roky

$30-250 CAD

Zaplaceno při doručení
Good evening, I have built myself a database over the last twelve months but have hit a road block and trying to find someone that could finish one last thing. When I save a record from my form I would like it to check for duplicates on my table in two columns. I have a MDW ID and a STATUSAUTO column in my table. When I save my record in the form it automatically sets the record on the tables STATUSAUTO to "In Progress". The table can have many MDW ID's the same if their statusauto is "Completed" but I only want it to allow one MDW ID if the statusauto is "in progress" Does this make sense? Multiple records with same MDW ID if statusauto is Complete Only one record allowed per MDW ID if statusauto is "in progress"
IČ projektu: 18085361

O projektu

19 nabídky
Vzdálený projekt
Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
Hi there, Greetings! It's a 15 mins job for a pro. I can do it right now. Please send me your database or give me access to your machine. I will look forward to hearing from you. Thanks, Rayyan
$35 CAD v 1 dni
5,0 (17 recenze)
4,8
4,8
19 freelanceři nabízejí v průměru $94 CAD za tuto práci
Avatar uživatele
Hello! I am Paris and just had the chance to read your project's brief. I get that you are looking for an Access developer that will adjust the process of saving a record in your database. I am going to write some VBA code that will check the MDW ID and STATUSAUTO fields according to your guides. If STATUSAUTO is "in progress" and there's already a record with the same value there as well as the same MDW ID it will be neglected. Otherwise, it will be saved in the table. Are you in a hurry? I'm going to spend less than one day to complete your project for a total payment of $70 (a single milestone to be released once you're satisfied with the final file). I'm a very experienced and skilled Access developer as you can check for yourself in my page (https://www.freelancer.com/u/paris2785) where you'll get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$70 CAD v 1 dni
4,9 (114 recenze)
6,8
6,8
Avatar uživatele
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$50 CAD v 1 dni
4,9 (145 recenze)
6,5
6,5
Avatar uživatele
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. Based on your proposal I'll enhance your current Ms Access DB very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$250 CAD v 3 dnech
4,6 (47 recenze)
6,1
6,1
Avatar uživatele
Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you with this simple task. However, I'd like more details about the project. Check my profile for previous clients' reviews and projects. Looking forwards to hearing from you. Best, Alaeddin
$50 CAD v 0 dni
4,9 (72 recenze)
5,9
5,9
Avatar uživatele
Dear Buyer, I am working with access databases since 1998. Your requirement makes sense. I would be glad to assist you in this. Many thanks in advance for considering my bid. Looking forward to hearing from you soon. With best regards, Solon ...
$45 CAD v 1 dni
4,9 (24 recenze)
4,7
4,7
Avatar uživatele
Hi, I have a good experience in MS Access and Database Programming, etc... But I'm a new freelancer so I doesn't have lot of reviews in these relevant skills. But I confirm you I can release you from that road block (Just Fun) very well. Also if you want to negotiate budget and days I agree with it. Please contact me.. Regards, Zajjith
$90 CAD v 2 dnech
4,9 (20 recenze)
4,2
4,2
Avatar uživatele
Hi, I am a professional Access developer I have done many great projects in Access have a look at my profile Could you send me the file to check the problem ?
$77 CAD v 3 dnech
5,0 (6 recenze)
3,6
3,6
Avatar uživatele
I could provide a VBA code which will check the records by using SQL statement, do the update if there is "On Progress" field become "Complete", and then insert the new with "On Progress"
$55 CAD v 1 dni
4,8 (4 recenze)
3,6
3,6
Avatar uživatele
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
$155 CAD v 10 dnech
5,0 (4 recenze)
3,0
3,0
Avatar uživatele
Hello, Yes it makes sense and it can be done through a VBA code that connects an ADO connection method that basically checks the status before inserting the new records. I have done a similar example before that status of order is updated based on a set criteria of the order lines (one to many relationship) so even if the type of relationship allows you to insert multiple records with same ID but we can add an additional rule to be validated before inserting, and here we can derive it the same way. I hope that would answer your question Thank you Waseem
$60 CAD v 1 dni
5,0 (3 recenze)
2,8
2,8
Avatar uživatele
I have over 30 years' as a technical writer, developer, and CIO. I have created complex, menu-driven MS Access apps for large clients like AT&T, Cox Communications, shipping companies, and others. These are totally menu-driven, security-enabled applications that include functionality such as excel-enabled imports and exports, PDF reports, charts and graphs, snapshot reports, embedded Visual Basic and dynamic SQL, complex multi-level searches, and more. I find the multiple tables and relationships between them interesting. I also enjoy reporting and the challenges of presenting and manipulating data to provide the most benefit. Having presented to C-level executives (and having been one myself) I appreciate the criticality and value of properly designed databases and reports. They can speak volumes. I would like to be of assistance. Let's get started.
$220 CAD v 5 dnech
0,0 (0 recenze)
2,2
2,2
Avatar uživatele
I have 12+ years with multiple databases and would love to help you achieve your goals. Please provide more information about the project. Thanks.
$35 CAD v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I can do it
$155 CAD v 3 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
send me the data and I will fix the form and send it back tested within a couple of hours If you have other issues I might point to you about it specially in the database structure and its integrity
$155 CAD v 3 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z CANADA
Haileybury, Canada
5,0
1
Ověřená platební metoda
Členem od lis 3, 2018

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.