Remove the backlog associated with sending out and tracking purchase and change orders for marketing related promotional material associated with the products of a large pharmaceutical company. An OLE service was created that logs itself in every 15 minutes and checks to see if any new orders are in the database. The service builds an image of a purchase or change order complete with appropriate signatures, items, dollars and terms and conditions and faxes the order to the appropriate vendor. Written in Visual Basic 4.0 this application combines image processing with real time database access to provide the user with real operations time saving features. Provide real time status on numerous production time critical projects for several hundred clients within the bank.
Projects range in time from two hours to several months with extremely critical deadlines.
Linked Visual Basic, MS Access, and Lotus Notes in an integrated and organized environment to provide everyone with timely status and project information and capitalize on the strengths of each product. Provide the several hundred clients a small OLE object to submit requests and query status without bottlenecking the Notes database or constantly bothering the supervisors and team administrators. All Rights Reserved.