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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TheAxe

  1. TheAxe

    Need to Validate total of data on one form with static # on another

    No clue eh. I tried putting the rule on the total but no dice. Tried putting it on the field itself and having it do a sum and compare but again no dice. Its really a problem cause I got 2 other similiar situations now.
  2. TheAxe

    Need to Validate total of data on one form with static # on another

    Hi People! I have a form that lists all Customer Orders by Order: Date Product Quantity [Button to open shipping form] Today UselessJunk 50 When you press the button on any line it opens a small form that you can put in the shipping amounts. You can enter as many shipments as...
  3. TheAxe

    Is it Dsum or am I a dumbdumb?

    Sorry guys once I wrote it out a solution came to me: I did one Dsum for one field - Dsum for the other field. Its a massive statement but it works. Anyone think of a more elegant solution?
  4. TheAxe

    Is it Dsum or am I a dumbdumb?

    Ok I have a table for receiving goods (ReceiveGoods) and it has: 1] RecQty - thats the amount ordered 2] RecRec - Thats the amount received I have an inventory table for all my products which has: 1] Onorder Problem: I want to do: RecQty-RecRec by product in my Receiving table and place the...
  5. TheAxe

    Help - I can't design PO system to save my life...

    Thanx but unfortunately those wizards fail to take into consideration two major truths of buisness: 1] There are multiple POs under one invoice. 2] There are multiple invoices under one payment. Those are the problems that I can't solve. The rest is quite easy. I looked at the wizards but...
  6. TheAxe

    Help - I can't design PO system to save my life...

    I'm having a real problem trying to make an inventory, purchase order, invoicing, payment system. So far I got form to enter products. I got a form to order those products from our only supplier. This tracks the onorder and onhand. It all comes apart when I do the purchase orders from our...
  7. TheAxe

    How do I run an update query on just one record from a form?

    Hey its me I got a permanent handle. I work on every kind of IT project imaginable but I haven't touched access in literally years so its slow going. Thanks for your help it works. The funny part is I figured out after that I didn't even need to do it the way I wanted to. I was making the...
See more

Part and Inventory Search

Back
Top