Iam doing a sales and purchase management proj ...i need to implement a feature in which the stock updates like if it is out of stock it should notify me before a time period like 7 days or so///the front end is vb 6.0 and back end is sql server 2005

Do you have a table that lists the quantity? If so, you could create and use another table that holds notification info on when user should be notified when the stock is running low... Or for that matter you could append a field to the table... say iReOrdQty and use it to run a query against the iQty field...

strSQL = "SELECT * FROM tblStock WHERE iReOrdQty <= iQty"

Good Luck