En cours

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.

Regards

Load Planning Attachments Added.

Compétences : Excel, Microsoft, Microsoft Access, SQL, Visual Basic

Voir plus : 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

Concernant l'employeur :
( 4 commentaires ) Canal Winchester, United States

N° du projet : #1077468

Décerné à :

mray32

Check private message

180 $ USD en 2 jours
(1 Commentaire)
3.3

26 freelance ont fait une offre moyenne de 173 $ pour ce travail

mrbrave

Ready to start now...

200 $ USD en 4 jours
(77 Commentaires)
5.4
ExactSystems

You forgot to attach [url removed, login to view] see detail on PMB. regards

195 $ USD en 6 jours
(7 Commentaires)
4.9
ifaisal

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 en 15 jours
(10 Commentaires)
4.2
superMena2001

please check your PM

125 $ USD en 7 jours
(6 Commentaires)
4.1
PerfectSquare

please see the PM

150 $ USD en 5 jours
(29 Commentaires)
4.1
muthumuni

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

111 $ USD en 7 jours
(12 Commentaires)
3.9
mb01a

Please see my PM

250 $ USD en 5 jours
(1 Commentaire)
3.4
guevanjr

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

100 $ USD en 3 jours
(7 Commentaires)
3.3
ConsultOne

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 en 13 jours
(1 Commentaire)
2.8
proitagent

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

175 $ USD en 1 jour
(1 Commentaire)
1.7
iqbal9400

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

180 $ USD en 15 jours
(0 Commentaires)
0.0
ymeknassi

Hello, I can make it done ASAP!

70 $ USD en 4 jours
(0 Commentaires)
0.0
anthrosantos

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

250 $ USD en 7 jours
(0 Commentaires)
0.0
anquinton

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 Plus

120 $ USD en 10 jours
(0 Commentaires)
0.0
DataAppGuru

Please see PMB for details. Thanks.

50 $ USD en 2 jours
(0 Commentaires)
1.0
sekhar4dotnet

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 en 7 jours
(0 Commentaires)
0.0
andleigh007

Please give me this project to serve you sir/mam

250 $ USD en 15 jours
(0 Commentaires)
0.0
LuisGutierrez

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 en 4 jours
(0 Commentaires)
0.0
sourabh20

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 en 5 jours
(0 Commentaires)
0.0
Samtiger2

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 en 5 jours
(0 Commentaires)
0.0