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

Taidot: Tietokantaohjelmointi, Microsoft Access, MySQL, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: 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

Tietoa työnantajasta:
( 24 arvostelua ) -, Greece

Projektin tunnus: #16699239

Myönnetty käyttäjälle:


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 Lisää

€177 EUR 15 päivässä
(31 Arvostelua)

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 Lisää

€111 EUR 3 päivässä
(0 Arvostelua)

20 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

€277 EUR 12 päivässä
(373 arvostelua)

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 Lisää

€166 EUR 3 päivässä
(92 arvostelua)

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 Lisää

€253 EUR 15 päivässä
(62 arvostelua)

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 Lisää

€180 EUR 10 päivässä
(57 arvostelua)

A proposal has not yet been provided

€183 EUR 7 päivässä
(29 arvostelua)

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 Lisää

€250 EUR 5 päivässä
(46 arvostelua)
€188 EUR 10 päivässä
(37 arvostelua)
€150 EUR 12 päivässä
(14 arvostelua)

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 3 päivässä
(13 arvostelua)

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 Lisää

€250 EUR 10 päivässä
(11 arvostelua)

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 15 päivässä
(11 arvostelua)

A proposal has not yet been provided

€155 EUR 3 päivässä
(0 arvostelua)

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 5 päivässä
(0 arvostelua)

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 Lisää

€277 EUR 15 päivässä
(0 arvostelua)
€250 EUR 5 päivässä
(0 arvostelua)
€155 EUR 3 päivässä
(0 arvostelua)

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 Lisää

€211 EUR 3 päivässä
(0 arvostelua)
€250 EUR 7 päivässä
(0 arvostelua)