I would like to hire a Microsoft Access Developer
$30-250 CAD
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"
ID Proiect: #18085361
Detalii despre proiect
Acordat lui:
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
19 freelanceri plasează o ofertă medie de 94$ pentru proiect
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
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
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
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
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 ?
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"
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
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
I have 12+ years with multiple databases and would love to help you achieve your goals. Please provide more information about the project. Thanks.
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