Search results

  1. K

    Total and Average of Inventory Sold by rolling Daily, 30Day, 90Day, 365Day

    Hi... Access newbie here... TIA. I have sample data in the following form (dd/mm/yyyy): DateTransaction InvCodeID QtyOut 06/11/2023 YHH308B 2.5 12/10/2023 YHH308B 10 13/09/2023 YHH308B 12 09/11/2023 YHH200A 56 15/10/2023 YHH200A 22 06/09/2023 YHH100F 3 03/11/2023 YHH500F 8 I...
  2. K

    Office 2016 Navigation and Windows 7/10

    Hi All. Please see attached screenshots. In design mode, I have a vertical navigation control (tabs) and horizontal ones. Yet, when I use form view or layout view in Office 2016 on Windows 7, the left vertical pane disappears, but does not in Windows 10. I am sure it must be a simple setting -...
  3. K

    Update all records in subform

    I have created a Quotation form, that has a main form frmQuotationHeader, and subform frmQuotationLineItems. I have a UnitPrice field that is populated on the afterupdate event of the product selection. Ideally I would have solved this issue with an unbound form, but given that I want the price...
  4. K

    Calling public sub and updating all fields

    Hi. I have a navigation form that has tabbed subforms. Each subform deals with a differently calculated product and quantity, but similar calculated price formula. I cannot use a unbound field for the price, as I need the same price to show up years later, rather a newly calculated price when...
  5. K

    Sum of Totals of Subforms

    Hi All. My first post here... an Access noob, and learning fast :) I am designing a quotation that has a main form frmNewQuotation, and subforms frmLineItemCurtains, frmLineItemAccessories, etc, all linked by the Quotation Job Number. Each subform computes the unit qty, unit price, and...
Top Bottom