Search results

great, thanks a lot

sorry, attachment is here

thanks you. I am not sure this is what I need. have a look at the attached databse. open orders form, you will see a check box names completed. I need the filter to show only uncompleted (unchecked) orders in same orders form (without leaving it). can it be done, if yes, please explain how and...

I have a form that contain a subform. the main form displays Orders Table (client nam, purchse number, etc.. and a check box to indicate if the order is colpeted or not. the subform contain the order details (items, Qty, etc...). I want to add a button or a control that will allow me to see...

Thanks a lot

Dear all, I have a query that is based on orders table and contains "Qty", 'UnitCost', and "ctualUnitCost", in addition to yes/no control to indicate if "SalesTax" is applicable. I want an expression in the query to calculate total cost in one of 2 conditions: if no sales tax then TotalCost =...

many thanks, can not find words to express my gratitude

Can you please look at the attached database and tell me what is wrong. looks like I can not add records to the subform (message that a reuquired field in order table is missing, and I have no idea what it is). thanks a lot for your kind help and patience

thanks for the example. I do not see yet what I am doing wrong. I drged the subform to the mother form. what setup should I adjust?

Dear Friends, your help is very much needed. I have a form linked to Orders table (and has the field OrderID) and a subform linked to "Order Details" table and also has the field OrderID. both tables have one-many relationship via the OrderID. How to make the subform read automatically the...

is there a way to calculate/store total cost value of qty x unitcost in total cost field of same table. if it requires a query, would appreciate guding me how to write it.;) ;)

I have an "order" table that has Qty, unitcost, and totalcost as fields. I want a) make a query to calculate total cost in same table b) make a subtotal query (like the the one in northwind sample database) tp use in my main form to claculate grand total of all orders appreciate guiding me...

Hi, I have a report based on a query that supposed to show records of product name in products table but it shows the product ID instead, how can I do it

thanks but where should I put that code

I have 2 tables one for customer names and one for orders which contain the customer name. The form I am using is having a combo box to read from the customer table as an input method and selection will be writen to the "cutomer field" in order table. 2 issues: 1st is that the value enetered...

Dear all, I have a simple database with few tables for which I created forms for the user to enter data. I craeted in one ofthe forms a ombobox that reads from a table (list of suppliers fro example). I want the user to be able to select a supplier name and then this selected name will be fed...