How to do calculations on a form and store the results. Q: Rob Stoker writes: I have a table called “tblPartHistory” where I store the quantity of parts used in the field “quantity”. When I enter the quantity used into the form I want it to subtract the amount used from the table “tblPart” with […]
In response to my tip on Updating Word fields in Documents Created from Access Merge in AW 9.11, Peter writes: Note there is a significant issue in the section mentioned above. The code shown does _not_ update fields in headers or footers. Word doesn’t make it easy to work with those sections; you’ll need to […]
How to create an Excel timesheet, and export data from an Access timesheet. Q: Maurice writes that he needs to export Access timesheet data to an Excel worksheet for distribution, since some users don’t have Access, so he can’t just create an Access report. Is there a way to do this? A: I made a […]
How to find the Set Control Defaults in Access 2007. The handy Set Control Defaults command on the Format menu in Access 2003 (and earlier) can be hard to find in Access 2007. It is in the Controls group of the Design Ribbon, with a crossed tools and disc image:
How to suppress subtotals on reports. Q: Barbara Gorches writes: I am creating a report that needs to subtotal my detail records on several different levels. Level 1 – project phase totalLevel 2 – project totalLevel 4 – grand total This works fine, but when we have a lot of start-up projects there is only […]
