Đang Thực Hiện

Load Planning Database Ms Access

I am looking for an MS ACCESS expert who is very good with working on Reports. I have a spread Sheet that I would like to move into an Access Database. Please open the attached file (Load [url removed, login to view])

The database in the attachment is for example purposes to get you started.... OPEN THE DATABASE

This project involves 3 requirements.

1. Creating an import function & a Route Planning Form:

a) Create a function that Imports the Attached ".txt" Files into MS Access database and fill the table called "Tbl: Imported QAD Files". The text files come in every day, every hour so by the end of the day you've imported 8 files per supplier 1 for each hour. You need to include an indicator that shows when the file was imported(a new column showing date & time). The example table in the database is Tbl: Imported QAD Files

b) Route Planning:

Create a form that allows the user to plan # of Trucks and Routes. I've created a sample in a form called "Export". you need to Add the Planned Data sub form and allow the user to create results like in the table "Tbl: Planned Data" this has to be a very easy and quick proccess because there are over 50 Routes to be created.

2. Utilization Allocation:

a) Utilization by supplier in MS Access:

Look at the Queries in the database. It relates to the supplier tabs in the Excel. Most of the calculations have already been completed. Example: If you look at tab "CUSTOM MOLDED PRODUCTS" in the Load [url removed, login to view] and find "QRY: Sub Total Release.." in the database >>Filter>>DeliverDate "12/2/2010" You will see that the Utilization has already been calculated to match Utilization on the Excel sheet.

- You need this information for next step 2b.

b)Truck Assignment:

Assign Results of Utilization Calculation to Number of Trucks Assigned in 1(b) above. So when a file is imported the logic checks if that supplier has any planned trucks availlable then assigns all Orders to the availlable Trucks & Routes. If a truck is over capacity either because of (M3,Weight or skid spot) then allow the user to add an additional truck or reduce QAD Order quantities. Then generate Load Plan>>>

3. Reports:

Load Plan: Example in Excel

This report shows us how the Orders will be loaded on each truck and starting from skid spot 1 and which supplier orders are loaded. Each Route assigned in 1b that has orders in 1a should be shown in the report. If the Truck was over capacity when you calculated 2a then show BlowOut as shown in the attached example

Please review the attachment and ask any questions you may have before bidding. I am looking for a commited developer willing to work on other projects after this one.

Happy bidding.


Load Planning Attachments Added.

Kĩ năng: Excel, Microsoft, Microsoft Access, SQL, Visual Basic

Xem nhiều hơn: load planner access, load planning excel, xls excel expert, utilization review, starting with visual basic, planning an, need to find a ms access developer, ms project expert, ms access work, MS Access Database Developer, looking for access developer, i need a planner, import ms project, how to find a good developer, how to find a database developer, how to expert in excel, how to be an expert on excel, how to be an expert in excel, how to be an excel expert, function sheet sample, find an excel expert, find an access developer, find access developer, export from ms project, developer by the hour

Về Bên Thuê:
( 4 nhận xét ) Canal Winchester, United States

ID dự án: #1077468

Được trao cho:


Check private message

$180 USD trong 2 ngày
(1 Nhận xét)

26 freelancer đang chào giá trung bình $173 cho công việc này


Ready to start now...

$200 USD trong 4 ngày
(77 Nhận xét)

You forgot to attach [login to view URL] see detail on PMB. regards

$195 USD trong 6 ngày
(7 Nhận xét)

Hello I can do this for you. I have expertise in MS access and has developed number of similar applications. Please see my private message for more details. Regards Faisal

$250 USD trong 15 ngày
(10 Nhận xét)

please check your PM

$125 USD trong 7 ngày
(6 Nhận xét)

please see the PM

$150 USD trong 5 ngày
(29 Nhận xét)

Hello... #####... Can you Kindly see PMB for details ...##### Your satisfaction is my success muthumuni (Gold member) ................

$111 USD trong 7 ngày
(12 Nhận xét)

Please see my PM

$250 USD trong 5 ngày
(1 Nhận xét)

I'm a experienced dba and systems developer. Ready to start.

$100 USD trong 3 ngày
(7 Nhận xét)

Please see my private message outlining the details of my bid. Please also send me the sample details which are missing from your bid outline

$350 USD trong 13 ngày
(1 Nhận xét)

I am a ms access profi and can easily do the job. Regards

$175 USD trong 1 ngày
(1 Nhận xét)

What is you want I am ready to fulfill your demand.

$180 USD trong 15 ngày
(0 Nhận xét)

Hello, I can make it done ASAP!

$70 USD trong 4 ngày
(0 Nhận xét)

I cannot find the attachment/s. I can do this project.

$250 USD trong 7 ngày
(0 Nhận xét)

I require any sample forms, database and information to be used to create this project. I also need to know it this database will be a single user database or a multi-user database and which version of access will be Thêm

$120 USD trong 10 ngày
(0 Nhận xét)

Please see PMB for details. Thanks.

$50 USD trong 2 ngày
(0 Nhận xét)

Hi I have lot of experience in developing MS Access database tools and reporting package for small medium companies. Example: Reliance ,Uninor projects are handle for Company. Thanks, sekhar

$100 USD trong 7 ngày
(0 Nhận xét)

Please give me this project to serve you sir/mam

$250 USD trong 15 ngày
(0 Nhận xét)

I'm a MS Access expert since 2002, MS Excel since 1998, some C++ experience since 1999 and Java since 2006. Let's keep it easy and scalable.

$90 USD trong 4 ngày
(0 Nhận xét)

Hi I have lot of experience in developing MS Access database tools and reporting package for small medium companies. I would like to implement this project as well. Thanks, Sourabh Bansal

$300 USD trong 5 ngày
(0 Nhận xét)

Access Expert Here !! Ready to start right way. Hope to achieve next positive feedback from you !!! Please check you inbox. "Always willing to walk extra miles to achieve Excellence"

$250 USD trong 5 ngày
(0 Nhận xét)