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!

Search results for query: *

  1. onusonu

    do not show seleted item in comb box if select

    Hi, I have a combo box with three values: oz, lb, g. When one of the item is selected, say oz, I want to drop down box to exclude the seleted item so that the only option they have is lb or g.
  2. onusonu

    invalid use of null when reach to textbox with no value

    Me("Wt" &CStr(i)) refers to each textbox. Wt1, Wt2, Wt3...Wt13
  3. onusonu

    invalid use of null when reach to textbox with no value

    Hi PHV, with the code you showed me, it gave me "invalid use of null" message
  4. onusonu

    invalid use of null when reach to textbox with no value

    Thank you, but now i have another problem. when I have 3 textbox with numbers, it loop through the 3 textbox and repeat 2 more times. And when I have 7 textboxes with numbers, it loops through the 7 textbox and another 6 set, each 7 times. I can't see why it's doing that. Function TotalW() As...
  5. onusonu

    invalid use of null when reach to textbox with no value

    How do I get it to stop when the record is null instead of getting the error "invalid use of null" Function TotalW() As Double Dim TotalWeight As Double Dim SWeight As Double Dim count As Integer Dim TWeight As Variant Dim i As Integer For i = 1 To 13 If Not IsEmpty(TWeight) Or...
  6. onusonu

    Automatically calculate sum for each current record

    1. Yes, the unique field is product name, but a product can have multiple formulas. Say the product is Pepperoni pizza 9", which I choose from a drop down combobox cmbProduct. Then I have 5 columns of 13 rows of blank txtbox. the first column is the cmbID. I select an ID and the ingredient name...
  7. onusonu

    Automatically calculate sum for each current record

    Yes, I'm concern about 'real-time' reflection of the most current price. For example form Formulation Form Item # Ingredient Weight % Price it1 Ing1 Wt1 Per1 Cst1=Ing1.colum(1) it2 Ing2 Wt2.. Per2 Cst2=Ing1.column(1) it3 Ing3 it4...
  8. onusonu

    Automatically calculate sum for each current record

    The weight of an ingredient is fixed, but the pricing is not. Say, the price of romaine lettuce can increase or decrease depending on the weather and the demand. Some formula is made up of 10 items, other one 3 items. the price is retreived from another ingredienttable. When I update the price...
  9. onusonu

    Automatically calculate sum for each current record

    I have a form that calculates the cost( Cst1, Cst2, Cst3...Cst13)of each items that goes into, say pizza. The price changes constantly. I have to click "calculate" every time when I view the formulas to update the pricing. How do I get the total pice automatically reflect the new cost of each...
  10. onusonu

    populate txtbox with value from multi-selected list box, no skip txtbx

    How simple. Thank you! PJ
  11. onusonu

    populate txtbox with value from multi-selected list box, no skip txtbx

    The code below allows me to select multiple values from list box and automatically populate the selected values to textboxes. The problem is that if I select, say, item1, item2, and item 5, those items will populate txtbox1, txtbox2, and txtbox5, leaving txtbox3,4 empty. How do I get it to...
  12. onusonu

    using wildcard with BETWEEN..AND operator

    Thank you all, Very helpful!
  13. onusonu

    using wildcard with BETWEEN..AND operator

    I'm trying to use wildcard with BETWEEN..AND statement. I want to have an option to typ in the 1st and 2nd to retreive a range of date or nothing to get all the record or provide only the 1st date that will return all data with date equal to or greater than the 1st date. Here is my statement...
  14. onusonu

    populate textboxes automatically after combobox is selected

    Now if I don't want to use the list box with "multi-select," how would I populate the items from specific supplier after selecting a supplier in the cmdSupplier combox onto textboxes (txt1, txt3, txt3, etc.)? PJ
  15. onusonu

    populate textboxes automatically after combobox is selected

    Thanks for the help. I got it. I changed Me("Order" & CStr(intI + 1)) = ctl.ItemData(varItm) to read Me("Order" & CStr(varItm + 1)) = ctl.ItemData(varItm). PJ
  16. onusonu

    populate textboxes automatically after combobox is selected

    Thanks for the tip. I checked out the vb help and it got me partially there. Here's the code Private Sub cmdOrder_Click() Dim frm As Form, ctl As Control Dim varItm As Variant Dim intI As Integer Set frm = Forms!PurchaseOrderForm Set ctl = frm!lstItems For intI = 0 To...
  17. onusonu

    populate textboxes automatically after combobox is selected

    Thank you! That sounds like a good idea. Once the user select the items from the list box and click "finished," how do you get those item to populate to individual text box so amount can be entered for each item. I have minimal knowledge on VB codes and I don't have a clue. Please help. PJ
  18. onusonu

    populate textboxes automatically after combobox is selected

    Hi, I have an order form containing one main combobox(cmbSupplier) and 30 blank comboboxes (cmbitem1...cmbitem30) and 30 amount textboxes (txtamt1..txtamt2...txtamt30). cmbSupplier contains all the suppliers. When a user select a supplier, only the items that are supplied by the selected...

Part and Inventory Search

Back
Top