Make your own free website on Tripod.com

Back

frmLogon

This form is used to log on to the oracle database hosted by my computer. The user enters their user id and password. The password box uses asterisks to make sure that no one can see the password. When the 'OK' button is pressed, the database makes sure no fields are null and then tries to logon to the database. If the username and/or password is invalid, the error is trapped from oracle and a message is displayed to the user.



frmMain

This form is the main switchboard. All operations can be performed from here. This form also has fields at the bottom for the current user and the time.


frmSelectGaragePurch

This form is used to choose a garage that is  making a new purchase. It contains a combo box that is populated with all of the garages in the table. The 'Select' button will be disabled until  a garage is chosen from the combo box. When 'Select' is clicked, it will open the form frmNewGaragePurch to enter a new purchase for the garage that was selected.


frmNewGaragePurch

This form is used to enter a new garage purchase. The form frmSelectGaragePurch is used to choose the garage that is making the purchase. The time and date fields are calculated and automatically filled in. The purchase number is automatically calculated based on the last number in the database. To add a new item, the user  clicks the 'Lookup' button by the next available blank item no box. The new item is chosen and added from the frmChooseItem form. After choosing an item, the quantity for that item line
will get focus so that the user can enter the quantity. The line 'Total' and 'Order Total' will be automatically calculated. After an item is added, the button on that line will change to 'Clear' to allow the user to remove the item from the order. The 'Add Purchase' button will be disabled if there are no items  in the purchase. The 'Cancel' button will prompt the user before closing the form.


frmChooseItem

This form is to add an item to a new garage order. The user must first choose a category, then an item. The 'Add to purchase' button will be disabled until both a category and product are chosen. When the button is pressed, it will add the item to the current garage purchase.


frmLookupPurchase

This form is used to select a specific garage and purchase to lookup the information about that purchase. The user must first choose a garage. The garage combo box is populated with only garages that have made a purchase. Once the user chooses the garage, the second combo box will be populated with all the purchase dates and times for the garage that is selected in the first combo box. The 'Lookup' button will only be enabled once a garage and specific purchase have been selected. When clicked the form frmGaragePurchase will be opened to view the order details.


frmGaragePurchase

This form is used to lookup a garage purchase that was previously entered into the database. The form frmLookupPurchase is used to choose the garage and the purchase. The form contains the garage name, the order number, the date and time, as well as the information about the item(s) that were purchased. All fields are locked and any fields not used will be grayed out and disabled.


frmAddNewPart

This form is used to add a new part to the store inventory. All information must be filled in or it will not allow the part to be added. The category field contains a combo box that is populated with all the categories that are currently in the database. The user can select one of the existing categories or create a new one.


frmNewRecord

This form is used to add a new garage to the database. The Garage ID is locked and is automatically calculated based on the last Garage ID in the table. There is a button to clear all the fields, to save the record and to cancel. The 'Save' button will make sure that there are no null fields and that the data is in the proper format. If all the conditions are met, the new garage will be saved The 'Clear Fields' will erase the values  in all of the fields. The 'Cancel' button will prompt the user before closing the form.


frmGarageLookup

This form is used to choose a garage to view or change the information for a specific garage. It contains a combo  box that is populated with all garages that are in the database. The 'Lookup' button will be disabled until a garage is selected. When pressed, the button will open the form frmGarageInfo to view the information for the garage that is selected.


frmGarageInfo

This form is to view and/or change info about  a specific garage. the garage is chosen from the frmGarageLookup form. The save changes button, when clicked will make sure that all fields are filled in with appropriate values and if so, save the record. The close button will prompt the user to make sure that they want to close without saving. If they do, it will close the form. If not, it will return to the form.


frmAbout

This form displays the information about the database. It includes the purpose and also my name.

Back