|
|
|
Microsoft Office Software
|
Can I scroll through years rather than months on a date chooser. (May 06 2008 12:55 GMT) - In a form on Access 2007 I have a date field that populates with a calendar function when I select it, problem is, I am selecting peoples date of birth and when it opens it opens on todays date, I can scroll back in time month by month but dont appear to be able to do it by year which is what I want to quicken things up, any ideas welcomed. |
Microsoft Office Software
|
Total of Subform (May 06 2008 12:54 GMT) - Access 2007 I have a mainform which contains a subform The mainform contains details of the finished item the subform contains details of the finished items parts Eg Main form = Table = sum of 4 x 10 + 1 x 140 = £198 Subform = 4 x legs @ £10ea + 10% markup 1 x top @ £140 ea + 10% markup I would like the mainform to have a running total of how much the item is costing as new lines are added to the subform. Subform contains Itemdesc ItemQty ItemUnitRate ItemMarkUp% ItemSaleValue - this is a calculated field ...... =(ItemQty*ItemUnitRate)+(ItemQ Mainform contains FinItemDesc FinItemQty FinItemSalValue - it is this field that I cannot calculate. I want it to equal Sum(ItemSalValue) * FinItemQty I have tried adding a calculated field in the footer (txtItemTotal) of the subform as: sum(ItemSaleValue) and a calculated field in the mainform as: |
Microsoft Office Software
|
Total of Subform (May 06 2008 12:54 GMT) - Access 2007 I have a mainform which contains a subform The mainform contains details of the finished item the subform contains details of the finished items parts Eg Main form = Table = sum of 4 x 10 + 1 x 140 = £198 Subform = 4 x legs @ £10ea + 10% markup 1 x top @ £140 ea + 10% markup I would like the mainform to have a running total of how much the item is costing as new lines are added to the subform. Subform contains Itemdesc ItemQty ItemUnitRate ItemMarkUp% ItemSaleValue - this is a calculated field ...... =(ItemQty*ItemUnitRate)+(ItemQ Mainform contains FinItemDesc FinItemQty FinItemSalValue - it is this field that I cannot calculate. I want it to equal Sum(ItemSalValue) * FinItemQty I have tried adding a calculated field in the footer (txtItemTotal) of the subform as: sum(ItemSaleValue) and a calculated field in the mainform as: |
PropertyMagnate Blog
|
Tuesday morning linkage - nest eggs in danger (May 06 2008 12:54 GMT) - Mittal makes offer Hunt can refuse [Sunday Times] Nest eggs in danger [Daily Mail] Blairs buy Gielgud’s former home [Telegraph] Elle Macpherson to quit London, expect to see house for sale soon [Sydney Morning Herald] How low could they… Original post by Click here and PropertyMagnate.com Tags Linkage |
SeekingAlpha.com: Home Page
|
Bernanke Urges Action to Slow Foreclosures (May 06 2008 12:54 GMT) - Michael Shedlock submits: Bloomberg is reporting Bernanke Urges Action to Slow Jump in U.S. Home Foreclosures. Bernanke, in a speech in New York yesterday, also reiterated his call for lenders to forgive portions of mortgages for some struggling homeowners. |
Digg / Environment / upcoming
|
The Greening Of Capital Hill (May 06 2008 12:54 GMT) - Despite all the talk in Congress about reducing greenhouse gas emissions, it's not so easy greening the Capitol itself. For one thing, there's disagreement over how much it should cost for the Capitol Power Plant--which provides heating and cooling power to Congress--to use cleaner-burning natural gas instead of coal power |
Celebrity Shots
|
Christina Aguilera Had Some Fun (May 06 2008 12:54 GMT) - Christina Aguilera was seen leaving Crown Bar in Hollywood with her husband Jordan and appeared a bit drunk/tipsy. Her husband had to guide her out of the club and into their car as I guess she had more than a drink or two. |
|