Search results

  1. J

    flow control

    Hello. This is a question about the flow of control regarding a Combo Box. In the event, NotInList, I have code entering the value entered into the list. What is the event called directly after the After_Update() method for the combo box? Thank you.
  2. J

    Problem with query structure

    Hello... Attached is the access db I am working on. My problem is in the following code: (Sorry for this. I don't know how to place code into a thread.) Private Sub cmbxMainCatName_AfterUpdate() Dim updateString As String lblSUBCATEGORYTitle.Caption = cmbxMainCatName.Value...
  3. J

    Summing over values in a related table

    Hello. Thanks for the help above. Suppose I have the following tables: tblCategory --> CatID, CatName, totalSpent tblItem --> ItemID, ItemName, ItemCost, ItemCat, RecID, CatID tblReceipt --> RecID, RecStore, totalCost These tables have the following relationships: CatID<(1)--(Many)>ItemID...
  4. J

    Summing over values in a related table

    Thanks for the reply. I saw that about my choosing name as field properties....thanks....CategoryName and ItemName are better. tax_percentage would be a constant. If tax is to be applied to an item (as indicated by the tax(yes/no) field), then the formula calculating totals would reflect...
  5. J

    Summing over values in a related table

    Hello. This is my first post. I am making an attempt at learning Access and have run into a wall. Just wondering if anyone can give me hand. :confused: Let me set up the problem. I have 2 tables: tblCategories ---> CategoryID, name, totalSpent tblItem --> ItemID, name, price...
Back
Top Bottom