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.

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

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

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

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

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