Search results for query: *

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.

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

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

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...

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...

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...

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...

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...

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...

How simple. Thank you! PJ

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...

Thank you all, Very helpful!

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...

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

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

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...

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

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...