I gang


we are looking for someone with experience with ms access 2010 front end and MySQL database back end . We would like to re write our existing purchasing software which is in access and cannot meet our requirements any more.

we will provide MySQL database and you need to fix errors may appear when using access front end.

also following forms and reports should be created in access :

A. Requisitions – Edit and send as email attachment ( EXCEL format ) to Ship Chandlers

B. Quotations – Receive quotes in excel format sent via requisitions and a script will auto import to database

C. Create Comparison and export to excel format between 4 different suppliers

D. Orders – Create orders and send to supplier(s) via email attachment ( PDF –EXCEL ) format

[login to view URL] – Shows number of requisitions received but not yet send to supplier and another visual report on dashboard shoes orders send and not yet closed as delivered

You cannot change following changes included in mysql database :

- Tblrequisition

- tblrequisitionsuppliesdetails

- tblrequisitionsparesdetails

- impa

- tblcurrency

- tblsupplyunit

- tblsupplydepts

Master table is tblrequisition and child tables are tblrequisitionsuppliesdetails ( conditions where tblrequisition.RequisitionLink=1) and tblrequisitionsparesdetails ( where [login to view URL]<>1) / MASTER/DETAIL connect tblrequisition.idcounter=[login to view URL] AND tblrequisition.idcounter=tblrequisitionsparesdetails.EnquryLink.

So basically there are two (2) main categories the SPARE PARTS and all others i.e. SUPPLY .

Various automation will be required like copy items from one requisition to other, split orders to different suppliers, agent details to be printed on order form, payment terms to be printed on order form , also when user edit a requisition autofill option should be available more specifically when they enter short code it look up impa table and auto fill description , check dublicates on a requisition and give the option to auto delete etc.

ALSO orders currency depends location of supplier i.e. can be euro , sgd other BUT all being converted to USD for budget analysis - you can see that in details tables where there are columns for usd conversion .

Office user should have the option to add / create a new requisition in our new purchasing software

1- Requisitions (view/edit/create) - filter based on various criteria like completed rfqs or not , per vessel , per category

2- Quotations (view-edit)

3- Comparison (create/view)

4- Order (create/view) - split items to most cost competitive if required

5- Dashboard

6- Screen to add/edit suppliers

Evner: Programmering af database, Microsoft Access, MySQL, PHP, Software Arkitektur

Se mere: front end for mysql database, mysql front end, how to connect ms access to mysql database, access to mysql migration, connect ms access to mysql web server, how to create odbc connection for mysql database, import access to mysql, microsoft access mysql odbc driver, tim finch contract mysql ms access vba sql server database developer, access 2010 front end internet, use sharepoint 2010 front end access 2010 database, microsoft access 2010 create invoice database, microsoft access 2010 simple invoice database, access 2010 end database sharepoint, front end end access 2010

Om arbejdsgiveren:
( 24 bedømmelser ) -, Greece

Projekt ID: #16699239

Tildelt til:


good afternoon. I am rebidding on your project. I have read the description. I am ready to start. Mypassion is building Custom Access Databases. I have built well over 300 custom databases in the past 19 years. I hav Flere

€177 EUR in 15 dage
(31 bedømmelser)

My budget is very low. I read your job description and understood. So I'm an ms access expert, and mysql. you can use mysql_odbc to communication between ms access and mysql database. I'd like to interview with yo Flere

€111 EUR in 3 dage
(0 bedømmelser)

20 freelancere byder i gennemsnit €208 på dette job


We have successfully finished over 520 projects in last 18 years. ID : 16699239 Greetings, We are interested to work on this project, please find my comments inline with yours, 1. MS ACCESS 2010 FRONT END - MYS Flere

€277 EUR in 12 dage
(373 bedømmelser)

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Flere

€166 EUR in 3 dage
(92 bedømmelser)

Hi , l am very intrested to work on your project. I have more than 15+ years of experience in Web Development and around 1000 projects finished with success and some of them can be seen on freelancing websites Pleas Flere

€253 EUR in 15 dage
(62 bedømmelser)

Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. Let me know the full specification of the project to calculate the approp Flere

€180 EUR in 10 dage
(57 bedømmelser)

A proposal has not yet been provided

€183 EUR in 7 dage
(29 bedømmelser)

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I'm Ms Access/VB/SQL/Access/Excel programmer since 1997. Really all my projects here I've developed for Ms Flere

€250 EUR in 5 dage
(46 bedømmelser)
€188 EUR in 10 dage
(37 bedømmelser)
€150 EUR in 12 dage
(14 bedømmelser)

We have expert in wordpress, web development, php,html, css, jquery,woocommerce, MySQL, CakePHP, HTML5 ,Improve website speed [login to view URL] have very cost effective and always work done on project deadline

€155 EUR in 3 dage
(13 bedømmelser)

i want to develop the window form application for you. It will be user friendly and any number of users can use it. As you have domain knowledge and i have development knowledge, if you allow me to develop applicat Flere

€250 EUR in 10 dage
(11 bedømmelser)

Hi Sir, I just made a superstore application that overlaps your requirements. Moreover, I can complete this project in time and in the budget. Let me know if you want to see a demo.

€355 EUR in 15 dage
(11 bedømmelser)

A proposal has not yet been provided

€155 EUR in 3 dage
(0 bedømmelser)

Hi. I am an access and excel expert and can help you with the project . kindly go through my profile and connect with me if you would like me on board . Please send your files to proceed further

€166 EUR in 5 dage
(0 bedømmelser)

I hereby submit my offer to develop and supply the Ms Access/My SQL application you have described. I will bring ready experience developing Accounting and Purchasing Systems with Ms Access that run against SQL Servers Flere

€277 EUR in 15 dage
(0 bedømmelser)
€250 EUR in 5 dage
(0 bedømmelser)
€155 EUR in 3 dage
(0 bedømmelser)

I got more than 25 years in the computer field, specialized on the computer language and its programming; I come from the time when you had to type and analyzed a lot of code to get a "Hello world" on the screen. So Flere

€211 EUR in 3 dage
(0 bedømmelser)
€250 EUR in 7 dage
(0 bedømmelser)