Recent content by Diksha1310

Hi, can someone brief me on testing strategy, plan and results. Furthermore, i want to know what test datas there are for a field named title where its validation rule only allows it to enter alphabets? If i can get a sample of the chapter:SYSTEM TESTING of any project, it will really be...

Hi! Can someone tell me what is the validation rule for entering data in a particular format? For e.g, BookID must be in the format AAA999(for e.g,Hau344) ...values out of this format are not accepted(e.g,H4s09)!! Please help..:confused:

Yeah, on my form i add a new sale transaction. But do u hav any code for an update statement?

Hi! can someone help..very urgent. I'm computerising a bookshop. i have a stock table/form, sales and purchase table/form. When a customer buys a book, in my stock form QuantityLeft is obtained by a query which subtracts QuantitySold from QuantityInStock. I need a code or any method by which i...

Hi! can someone help! i have run a query for my purchases form, in which i've changed the RecordsetType to Dynaset(Inconsistent) in the query properties table..so that my query is not read only...which is a success! Now that the form is ready i can't add a new record,WHY??each time i click on my...

Ok!thnx i'll see..

Yeah, but all my tables have a unique primary key.. is there a soln?

SELECT tblPurchase.PurchaseID, tblPurchase.DatePurchased, tblStock.QuantityInStock, tblPurchase.QuantityPurchased, tblPurchase.[TotalCost($)], tblPurchase.InvoiceNumber FROM (tblSupplier INNER JOIN ((tblBook INNER JOIN tblStock ON tblBook.[BookID] = tblStock.[BookID]) INNER JOIN...

Can it be because it is one to many relationship!! The other reasons don't fit,..i did another query previously for my book form,..it was NOT read only though! i can;t understand why only this particular one.

I'm computerizing a bookshop. For my purchase form, i need the following tables: PurchaseID, DatePurchased, QuantityInStock, QuantityPurchased, TotalCost and InvoiceNum. But,...since they are not found on the same table, i did a query,..but the query does not accept any...

Thanx You were really helpful!

I'm making a pharmacy stock control system.. I want an updatable query which subtracts the field QuantityInStock from QuantitySold,so that i get QuantityLeft..(It must be calculated automatically).! Can someone help!:confused: