Purchase Solution

Create a Visual Basic Application

Not what you're looking for?

Ask Custom Question

The user should be able to do the following:

Scroll through the data records, showing all the fields.
Add a new parts record, delete an existing parts record, and update an existing parts record.
Create a sequential file with the inventory data.
Display the number of active and discontinued inventory parts.
Program Requirements
You must center the form on the screen.
In addition to the database fields, for each part in the inventory you must calculate and display
the gross profit (sales price - cost)
the total cost value of the part in the inventory (cost * quantity)
the total sales value of the part (sales price * quantity)
in 3 unbound control instances. These values should be updated when the current record changes.
Create a button and corresponding click event handler that will display a message box containing the number of discontinued inventory parts, and the number of inventory parts that are not discontinued.
You must use labels to make the application understandable.
You must catch any arithmetic exceptions that occur during calculations and display an error message
You must use at least one user-defined FUNCTION and one SUB procedure.
You need to provide a way to exit the program gracefully

Field Name Description DatA TYPE
Fld Part number Unique identification Number Integer
FldPart Description Description of part String
FldCost Cost of part Single
FldSalePrice Sale price of part Single
FldQuantityOnHand Number of items in inventory Single
FldDiscontinued True if the item is discontinued Boolen.

Purchase this Solution

Solution Summary

The solution assists with creating a visual basic application.

Solution Preview

To add a product click Add button. Then it changes to update button. Fill in the product fields then click Update button. If there is wrong field ...

Purchase this Solution

Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Networking Questions

This quiz consists of some basic networking questions.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

C++ Operators

This quiz tests a student's knowledge about C++ operators.