780.986.3777
1.866.9ABLEIT
Contact Us
Case Study #5
Home
Why Able
About Us
Services
Products
Case Studies
Testimonials
What's New
Contact Us
Special Offers
Useful Links
Site Map
<table width="98%" border="0" align="left" cellpadding="3" cellspacing="0"> <tr> <td class="justifyBold">A manufacturing company now has a custom program to allow their drafting / design engineers the effective use of the same part number system already defined within their corporate manufacturing program.</td> </tr> <tr> <td class="justifyBold">Problem: </td> </tr> <tr> <td class="justifycss">The company required a custom program to allow their drafting/design engineers the effective use of the same part number system already defined within their corporate manufacturing program. <ul> <li> Simplify the drafting process</li> <li>Reduce the number of times the same part information was being hand entered into various systems</li> <li>Streamline the system for increased efficiency</li> </ul></td> </tr> <tr> <td class="justifyBold">Solution:</td> </tr> <tr> <td class="justifycss"> An application that runs within the VBA environment in AutoCAD Mechanical and gives drafting/design engineers the ability to list inventory parts from within the corporate manufacturing program,“Visual Manufacturing”. <ul> <li> Quick part locating is provided by the ablity to query the inventory parts by: <ul> <li>Category </li> <li>Item number </li> <li>Description, </li> <li>etc.</li> </ul> <ul> <li>Preventing unauthorized users from gaining access and to restrict access to various areas of the program</li> </ul> </li> <li>Required part(s) can be selected and the then added to a drawing BOM inside the AutoCAD Mechanical drawing.</li> <li>The completed drawing BOM can be written back to Visual Manufacturing for use by various departments such as: <ul> <li>Purchasing</li> <li>Accounting </li> <li>Etc. </li> </ul> </li> </ul></td> </tr> <tr> <td class="justifycss"> We employed the following development tools: <ul> <li>VBA for AutoCAD Mechanical</li> <li> VB6</li> <li> Microsoft SQL Server, SQL Base</li> </ul></td> </tr> <tr> <td class="justifyBold">Result:</td> </tr> <tr> <td class="justifycss"><p>The program now gives drafting/design engineers the ability to list inventory parts from within the corporate manufacturing program. Originally written for the Edmonton Division it has since been rolled out to a second division in Vancouver, B.C.</p> <p> </p> <p><a href="case_studies_5_in.htm">Case Study 5</a></p></td> </tr> </table>
<< back
