INVENTORY MANAGEMENT 1.0

A solution to create offers from product description fragments, stored in an MS Access database.

This prototype emerged from the VBA project Autotexts 1.0. The problem with the Microsoft Word Autotext solution was that it did not scale, it was not suitable for concurrent access, and it was hard to maintain the set of Autotext fragments in a simple Word document template. The company indicated that they were interested in a more professional solution but later decided to go with an already existing and established application.

Main Window

In this prototype products are assigned to categories. The list of categories can be extended arbitrarily.

New Product

The button "Edit" can be used to edit the product description.

With "Settings" the template can be specified on which a final offer document will be based. Also the address database with the customer addresses can be specified here.

Settings

The button "New Offer" creates a new document based on the specified template. The address comes from the customer address database and the chosen product is attached to the document.

Offer-Template

MS-Access Address Database

Type	Freelancer Project Prototype
Environment	VisualBasic 6, Office 97 Professional (Word, Access), ODBC, OLE/COM
Link	inventory.tar.bz2 (8MB)