EXCEL VBA MACRO APPLICATION FOR SUPPLIER & BUYING CONTROL - 1618OCT20

INTRODUCTION

Excel is a magnificent tool and  when pushed to its limits can even help run entire Cycle In Controling Information Systems we needs. 

Organizations often manage their processes for longer than necessary on spreadsheets and documents until they find a better alternative. For organizations that are ready to create order from chaos while scaling up, consider these strategies on converting excel VBA macro to be one packed application.

 

GATHERING REQUIREMENT

Through gathering requirements, we and the client produce a design to build the application according to what they expect. Mindfield's clients have found success in making applications in purchasing especially to increase the ability to deliver customer value at each stage of the value chain, especially with pricing list decisions.

From these results we also decided to collaborate with an ms.access database as storage media.

HOW TO RUNNING

When the application starts running, the first thing that appears is the login form so that the user must enter the user id and password. With the hope that this application can not be used from a user who not be have an authorization access. a user who does not have

After the user login, a main menu will appear which consists of:

1. List User 
2. Product Type 
3. Product Code 
4. Product & Supplier Reporting 
5. Exit Application