Search results

  1. S

    Hiding Columns in Datasheet View Subform

    Hello! The problem at hand for me is to be able to hide columns in the datasheet view of a subform wherever "#Name?" appears (see attachment). For reasons I cannot control, the reason the error "#Name?" appears is because the recordsets (in this case Oct. 2005 onward) do not yet exist - for...
  2. S

    Hiding Columns realtime in Subform

    Hello! The problem at hand for me is to be able to hide columns in a subform wherever "#Name?" appears. My VBA experience is minimal to non-existent, but if a not so complex sample code exists out there then I'd appreciate any suggestions you may have. I have attached a print screen document...
  3. S

    Hiding Columns in Subform

    Hello All!, The results of a query by users are shown in a subform (in datasheet view) similar to this: Months 2004-2 2004-3 2004-4 2005-1 2005-2 2004-06 0.9840 2004-07 0.9969 2004-08 0.9800 2004-09 0.9850 2004-10...
  4. S

    Calculating quarters

    Hello All! I have data laid out as follows: Measure MonthYr Value Fixed Std Jan04 90% Fixed Std Feb04 95% -------- ------ ---- -------- ------...
  5. S

    Running Totals Query Help

    Hi - Once again I'm asking for your assistance. Ideally, below is how the form (and eventually a report) would look; the first three fields (ID, Date & Vol) I currently have in a table (tblMaster): ID Date Volume YTDTotal Q1Total CurrQTDTotal Q2Total A1 Jun-05...
  6. S

    Aggregate Query Problems

    Hello! .... I think I posted this in the wrong section of the forum, so here it is again and hope someone's kind enough to help. Basically, I've been asked to show (in a form as well as a report) results on a Monthly, Quarterly and Year-to-Date basis. The table structure I currently have is as...
  7. S

    Date Aggregates Calculations in Form

    Hello! .... Despite not being much of an Access person I've been asked to show (in a form as well as a report) to show results on a Monthly, Quarterly and Year-to-Date basis. The table structure I currently have is as follows (additional fields and/or tables can be added if it would help get the...
Back
Top Bottom