Question: Need help writing VBA code to do the following: ----> SlesOrders.mdb contains: Categories (Category ID, Category Decription), Customers (CustomerID, CustFirstName, CustLastName, CustStreetAddress, CustCity, CustState, CustZipCode,
Need help writing VBA code to do the following:
----> SlesOrders.mdb contains:
Categories (Category ID, Category Decription), Customers (CustomerID, CustFirstName, CustLastName, CustStreetAddress, CustCity, CustState, CustZipCode, CustAreaCode, CustPhoneNumber), Employee( EmployeeID, EmpFirstName, EmpLastName, EmpStreetAddress, EmpCity, EmpState, EmpZipCode, EmpPhoneNumber), LineItems (OrderID,ProductID QuotedPrice, QuantityOrder), Orders( OrderID, OrderDate, ShipDate, CustomerID, EmployeeID), Products(ProductID, ProductName, ProductDesciption, RetailPrice, QuantityOnHand, CategoryID), ProductVendors(ProductID, VendorID, WholesalePrice, DaysToDeliver), Vendors(VendorsID, VendName, VendStreetAddress, VendCity, VendState, VendZipCode, VendPhoneNUnber, VendFaxNUmber, VendWebPage, VendEmailAddress).



Use the file SalesOrders,mdb provided to create the following application: Create an application that allows the user to browse to a database file to select it (i.e., the one provided) using the File Open dialog, and then displays a form to let the user select a customer and a product. The form should display two, two-column listboxes, one for customers, and one for products. When the user selects a customer and a product, the application should display OrderDate, QuotedPrice, QuantityOrdered, and the ExtendedPrice for each order for the selected product placed by the selected customer. Customer Selection Choose a Customer from the following list: Choose a product from the following list: Suzanne Vescas Wil Thompson Gery Halmark Michael Devolio Kenneth Peacock John Viescas Laura Callahan Neil Pali su Jeffrey Davolio Margaret Peacock Trek 9000 Mountain Bike Eagle FS-3 Mountain Bike Dog Ear Cyclecomputer Victorie Pro All Weather Tires Dog Ear Helmet Mount Mirrors Viscount Mountain Bike Viscount C-500 Wireless Bike Computer Yplurile Advai Ild 2000 UHulk Nkoma Lok-Tight Hock Viscount Microshel Helmet Use the file SalesOrders,mdb provided to create the following application: Create an application that allows the user to browse to a database file to select it (i.e., the one provided) using the File Open dialog, and then displays a form to let the user select a customer and a product. The form should display two, two-column listboxes, one for customers, and one for products. When the user selects a customer and a product, the application should display OrderDate, QuotedPrice, QuantityOrdered, and the ExtendedPrice for each order for the selected product placed by the selected customer. Customer Selection Choose a Customer from the following list: Choose a product from the following list: Suzanne Vescas Wil Thompson Gery Halmark Michael Devolio Kenneth Peacock John Viescas Laura Callahan Neil Pali su Jeffrey Davolio Margaret Peacock Trek 9000 Mountain Bike Eagle FS-3 Mountain Bike Dog Ear Cyclecomputer Victorie Pro All Weather Tires Dog Ear Helmet Mount Mirrors Viscount Mountain Bike Viscount C-500 Wireless Bike Computer Yplurile Advai Ild 2000 UHulk Nkoma Lok-Tight Hock Viscount Microshel Helmet
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
