Search results

i'm sorry, i found it now thanks regards,

thanks for your reply is Allow edits a proberty in the property sheet, i can't find it or do you mean something esle?

hello guys, i want to prevent the stored data; thats mean if somebody wants to update the data he click on a boutton then he can update ,otherwise he can't update can you help me please? thanks with regards,

hello guys, I have done stock program in Microsoft access. I created a table with name Items. That table contains itemNo (the primary key). , itemDesc. , unit , and price attributes. Also I created a table with name Sales which contains sales's invoice No (sInvoiceNo) (the primary key), date...

i'm sorry Rabbie, maybe i didn't understand what you mean, what i mean that i enter the number manually ,not automatically, anyway i found a solution for my problem, i used the dlookup function in the beforeupdate event of the field itemNo thanks, regards

many thanks to you David and GalaxiomAtHome, you helped me alot my problem now is solved regards,

thanks alot GalaxiomAtHome i changed the inner join to left join and that was ok, but i still have somethings to ask you, all the records was viewed but there is no value in the totalProcurements field, i want to view 0 value in this field,how can i do this, i set the default value 0 but it is...

hello guys, i have a query that shows the balance of each item, here is the query SELECT Items.itemNo, Items.itemName, Items.type, Items.unit, Sum(Transactions.qtyIn) AS totalProcurements , Sum(Transactions.qtyOut) AS totalSales,totalProcurements- totalSales AS balance FROM Items INNER JOIN...

first, thank you Rabbie for your reply I generate the number myself. thanks with regards,

hello guys, i have a form that is called items, and it contains a field that is called itemNo and the type of this field is number. i want to do my own constraint which prevents the user to enter a number that is previously existed. i need your help please many thanks to you, bye