Skip to main content.

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
Main Window

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

New Product
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
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
Offer-Template

MS-Access Address Database
MS-Access Address Database

TypeFreelancer Project Prototype
EnvironmentVisualBasic 6, Office 97 Professional (Word, Access), ODBC, OLE/COM
Linkinventory.tar.bz2 (8MB)