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).

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),

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!