Create and fax a document from an Access form

Closed

Description

Our goal is to automate the process of formatting and faxing order information to several different dropshippers. Currently our Access database allows us to view and modify a customer order, preview the packing slip for that order, and print the packing slip. The problem is the labor-intense process involved in getting our orders to our vendors. Every day we ... 1) manually print each individual packing slip 2) sort the printed slips by vendor 3) print a cover sheet for each vendor 4) fax each set of orders to the appropriate vendor 5) update each order record with the date sent to vendor. WHAT WE HAVE NOW ... We have developed a "New Orders" Form with a dropdown list of vendors. When a user selects a vendor, the form is populated with a list of all new orders for that vendor. WHAT WE NEED TO ADD ... The following functionality needs to be added to our "New Orders" form. 1. Ability for the user to select and/or de-select any or all orders listed on the form 2. Button that will trigger the creation of a formatted document (see below for a detailed description) which includes data from all of the selected orders. This document should appear immediately in preview mode. 3. While in preview mode, the user should be able to click a button that will fax the document to the associated vendor. Once faxed, this document needs to be automatically saved in a specified folder using a predefined file naming convention. It should not be saved unless it has been faxed. 4. After a fax of orders is sent, each order record needs to be updated with the "Date Sent to Vendor". DOCUMENT DETAILS ... The document that is created will be a fax which includes order information that needs to be sent to the dropship vendor. The fax needs to include: 1. A cover sheet with specific vendor details as well as the number of attached orders. 2. One page for each order, formatted to our company's packing slip design.

## Deliverables

1) Part of this job is to consult with us on the best way to accomplish the required functionality. Since this functionality will affect our daily business operations, the proposed solution must be discussed before programming can begin.

2) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

3) Program/functionality must be tested and approved by us before payment is made.

4) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

5) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP Currently we are using MS Word 2002 and MS Access 2002. These can be upgraded if it will significantly impact development and functionality.

Skills: Engineering, Microsoft Access, MySQL, PHP, Software Architecture, Software Testing

See more: which platform has the best for web development, what is the engineering design process, web software development document, web design and developed company sites, vendor database ms access, vendor creation form, the engineering design process, programming in access database, programming access database, print packing design, php programming problem set, packing design software, packing design page, new hire information form, new hire form, needs of a buyer, ms access web development, MS Access programming, ms access database development, legal consult, labor ready, labor hire, labor for hire, job ms access, hire day labor

Project ID: #3498536

2 freelancers are bidding on average $297 for this job

vbcodepro

See private message.

$127.5 USD in 10 days
(52 Reviews)
5.0
mapangvw

See private message.

$466.65 USD in 10 days
(0 Reviews)
0.0