Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Greggscott47

    Update query - Help

    cthanks for the advise any ideas who i can put that in my qury then thanks alot gregg
  2. Greggscott47

    Update query - Help

    i have an update query which , runs after i close a form from my orders , but all i want the query to do is to update the new information , at the moment it updates all of the information in from my one table , all i want it to do is update the information which has not allready been updated...
  3. Greggscott47

    Updating Tables

    i have a multi table database i have 2 tables in there which are related by the product id , i want the product table with the qty_in_stock to be updated , when a value is entered in the order table what i want it to do is update the qty when the value is altered in the order table or a...
  4. Greggscott47

    Updating Tables

    any more help people i am stoill stuck with this one
  5. Greggscott47

    Updating Tables

    i think the froms are linked by order id and ther is no table with all the fields in , but there is a query with them in thanks a lot gregg
  6. Greggscott47

    Updating Tables

    hi the qty of stock is stored in the products table field name (QtyinStock) the odrder qty which field name is (qty) is stored in order_details table , in the overall order from i have the fields Order ID Customer ID Order_Date Customer Name Address Area Post Code Country and subform...
  7. Greggscott47

    Updating Tables

    i can not get that one working m8 any other ideas , it says there is a wrong ending to the code thanks again gregg
  8. Greggscott47

    Microsoft access help again

    hi this for is made up from a query , which you have to enter the order number to get the information , and there is also so fields from the product table in the form so the main form and subform are not linked , but the subform and the main form both take information from the query thanks...
  9. Greggscott47

    Microsoft access help again

    hi i have a invoice form and a subform , which is based on a query , for the query you have to enter the order number , to see the values of that order BUT on the form i have to enter the number once for the main form and then again for the subform , is there anyway i can just enter the...
  10. Greggscott47

    Updating Tables

    hi i have a mail ordering system database which i am creating , i have a link table in i witch is my orders , what i want to do is when i enter an order of a certain qty in my order form i want it to update the qantity in stcok in my product table can any body please help

Part and Inventory Search

Back
Top