Merhaba Acil bi şekilde donem odevimi yapmam gerekiyor fakat gercekten yapamıorum cıldırmak uzereyim nolur yardım edin
.Database i hazırdır sadece kodlara ihtiyacım war

(TURKCE ACIKLAMA:a) bir listbox a stokta olmayan urunleri ve stokda olmadığı halde sipariş verilmiş urunleri yani quantity değerleri 0 ve - derğerli olanları listbox bastırmanızı istiyorum.

b)Gun icersinde siparişi verilen tum urundetaylarını Muşteri detayları ile listbox a basılacak.(Bir muşteri aynı gun icersinde bir sipariş verdiğini farzedin dolayısıyla databasedeki siparişler ogunne ait olacak tarih ile ilgili herangi bir sey yapmanıza gerek yok)

eğer stokta urun yoksa bunuda listbox ta belirtin ekteki inventory.exe aplicasyonunu incelerseniz daha acık olacaktır sizin icin .)
Term Project

The database MICROLAND.MDB (on the accompanying CD) is maintained by the Microland Computer Warehouse, a mail-order computer-supply company. Tables 10.5 through 10.7 show parts of three tables in the database. The table Customers identifies each customer by an ID number and gives, in addition to the name and address, the total amount of purchases during the current year prior to today. The table Inventory identifies each product in stock by an ID number and gives, in addition to its description and price (per unit), the quantity in stock at the beginning of the day. The table Orders gives the orders received today. Suppose that it is now the end of the day. Write a program that uses the three tables to do the following:
(a)Display in a list box the items that are out of stock and therefore must be re-ordered.

TABLE 10.5 First three records of the Customers table.

custID

1
2
3

name

Michael Smith
Brittany Jones
Warren Pease

street

2 Park St.
5 Second Ave
7 Maple St.

city

Dallas, TX 75201
Tampa, FL 33602
Boston, MA 02101

amtPurchases

234.50
121.90
387.20






FirFirst four records of the inventory table.

itemID

PL208
SW109
HW913

description

Visual Basic
MS Office Upgrade
PaperPort ix

price

89.50
195.95
300.25

quantity

12
2
8




TFirst four records of the Orders table.

custID

3
1
1
2

itemID

SW109
PL208
HW913
PL208

quantity

1
3
2
1



(b) Display in a list box bills for all customers who ordered during the day. (You can assume that each customer only calls once during a particular day and therefore that all items ordered by a single customer are grouped together). The bill should indicate if an item is currently out of stock.
__________________