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!

  • Congratulations biv343 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. johnnybwis

    Can I sum a calculated text box

    Text box 53 has =[UnitsReceived]*[Subtotal] Text box 55 in footer has =Sum([Text53])
  2. johnnybwis

    Subform line total to Table

    I check out the FAQ and understand better but now have a new question on my report. I do the calculation on the report with text box statement. =[UnitsReceived]*[Subtotal] but now need to do a total on that field so I inserted another text box in the footer with =Sum([Text53]) but do not...
  3. johnnybwis

    Subform line total to Table

    Ok I did leave it and do have a report that now does the calculation. I don't understand why a change in [Subtotal] ([UnitsReceived] cannot change) would be a problem, it should change in the table just as [Subtotal] would. Sorry but I do not know what a nomilization problem is. Thanks...
  4. johnnybwis

    Subform line total to Table

    I have a subform in data sheet view that gets a total using =[Subtotal]*[UnitsReceived] in the control source But I need this information to go to the table field unit weight How would I do this?
  5. johnnybwis

    Subform combo selections disapear/reapear

    Subform choice is limited by mainform choice with rowsource SELECT DISTINCTROW Products.ProductName, Products.ProductID, Products.NumberPerUnit, Products.WeightPerThousand FROM Products WHERE (((Products.CustomerID)=[Forms]![Purchase Orders]![SupplierID])) ORDER BY Products.ProductName; When...
  6. johnnybwis

    Should be simple, dlookup or column count

    Boy come back a week later and its even difficult to understand what I wrote, anyway I did get the DLookUp to work you just have to spell DLookUp correctly, also got the column count to work also but neither of these will actually work for me as I need be able to manually change the unit count...
  7. johnnybwis

    Should be simple, dlookup or column count

    Thanks for the reply but still no go
  8. johnnybwis

    Should be simple, dlookup or column count

    Ok, I'm new at this but here is what I have. It's subform that is limited by a selection in the main form - this works OK but I need some more fields to fill in on the subform. I first tried in the rowsource of the txtUnitcount = Dlookup("NumberPerUnit", "Products&quot...
  9. johnnybwis

    FAQ 702-681 combo limited by other combo

    Thanks for the response. The first query is stored in a rowsource [ProductId] in a subform called [Purchase Orders Subform]so that query would have to stay the same as it is in a Subform and looking at a control in the Mainform(right??). The second query is stored in a rowsource [UnitCount]in...
  10. johnnybwis

    FAQ 702-681 combo limited by other combo

    I have the subform cmbo which is limited by the selection in the mainform but I need cmbo in the subform to be limited by that subform selection. Do I need to name the form and then the subform also? This works for my first selection. Row Source SELECT DISTINCTROW Products.ProductName...
  11. johnnybwis

    Subform needs to get more

    I have a subform that limits its choice with a query on a combo box in the mainform but need to bring two more fields over. I tried to query the combo box in the subform but thing I am going at this the wrong way. What I want to do is in main form select customer, subfrom limits choice to...
  12. johnnybwis

    Requery subform when main cbo changes

    I have a subfrom that runs a query on a cbo in the main form (Pick customer on main form and subform cbo choices are products associated to that customer) but need the subform to requery if the user goes back and changes the mainform cbo. Currently there is a requery on subform on enter and exit...

Part and Inventory Search

Back
Top