How to print a report footer “page X of Y”, where X is the current and Y is the total. Q: Don Fox wants to know how to print a report footer “Page x of y”, where x is the current page and y is the total number of pages. A: Use the following expression […]
Here are a couple of methods for creating calculations in queries vertically. Q:Gang Wei writes to ask whether it is possible to create calculations in queries not only horizontally (like Total Cost: [UnitPrice] * [Quantity]), but also vertically, pulling in data from multiple rows. A:Yes, this can be done in two ways. One (the more […]
Access Archon #172 Using the AddItem and RemoveItem Methods The frmPairedListboxesMethodsUnsorted form uses the new AddItem and RemoveItem methods to move items from one listbox to the other. You can’t simply iterate through the ItemsSelected collection of the listbox, and use the appropriate method, since using AddItem or RemoveItem clears the selections, so I […]
Microsoft Australia is trying to lure Aussies to buy Office 2007 with petrol. Down in Australia you can buy Office 2007 and get money back for petrol see Office 2007 plus petrol
Q: Bradley Wellard writes: “I am still a bit of a novice and have been attempting to find some useful information on how to apply/use ActiveX controls in Access with little success. I am particularly interested in any information regarding the Microsoft ImageCombo Box control V.6. Are you aware of any sites and or publications […]