I would like to hire a Microsoft Access Developer

Finalizat Postat la acum 5 ani S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

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"

Microsoft Access

ID Proiect: #18085361

Detalii despre proiect

19 propuneri Proiect la distanță Activ acum 5 ani

Acordat lui:

rayyankabir

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

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% CAD în 1 zi
(17 Recenzii)
4.8

19 freelanceri plasează o ofertă medie de 94$ pentru proiect

paris2785

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 V Mai multe

$70 CAD în 1 zi
(114 recenzii)
6.8
VladimirLilenko

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 possibl Mai multe

$50 CAD în 1 zi
(145 recenzii)
6.5
zu02

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 Mai multe

$250 CAD în 3 zile
(47 recenzii)
6.1
alaeddindhahri

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 Mai multe

$50 CAD în 0 zile
(72 recenzii)
5.9
alekhine1962

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. W Mai multe

$45 CAD în 1 zi
(24 recenzii)
4.7
zajjithvedha

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 Mai multe

$90 CAD în 2 zile
(20 recenzii)
4.2
alhassanlatif

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 în 3 zile
(6 recenzii)
3.6
khanicha

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 în 1 zi
(4 recenzii)
3.6
carlosperezit

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 în 10 zile
(4 recenzii)
3.0
WaseemSh

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 Mai multe

$60 CAD în 1 zi
(3 recenzii)
2.8
nelson1812002

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 me Mai multe

$220 CAD în 5 zile
(0 recenzii)
2.2
acharyark

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 în 3 zile
(0 recenzii)
0.0
Kunaguaro

I can do it

$155 CAD în 3 zile
(0 recenzii)
0.0
medhatrabie

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 în 3 zile
(0 recenzii)
0.0