home *** CD-ROM | disk | FTP | other *** search
-
- Problem Menu-driven quote generator. User selects items to be included
- in quote by entering a number in a "QTY" column within a
- database. Database is simply a list of all items available for
- sale. Fields are set up for the following items: Part No, Qty,
- Descr, Unit price, Total price, Unit cost, Total cost, and GP%.
- See doc in AUTO123 file (7202) for some general tips on studying
- this application.
-
- Block Diagram
- __________________ __________________ _________________
- | | | |
- | | | Menu |
- | | Quote |_________________|
- | | | |
- | Database | | Macros |
- | |__________________| |
- | | | |
- | | | |
- |__________________| |_________________|
-
-
- Tips
- Macros begin at cell R22
- Main menu technique is unique.
- Option 1 uses Range Input command R25.
- Macro for generating quote S24. Also look at Data Query
- setting.
- Modify database macro techniques S48.
-
-
-
-
-
-
-
-
-