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 […]
How to get Access add-ins to work in Access 2007 running on Windows Vista. Access Archon # 162 Introduction I have add-ins that were originally developed in Access 97 that have worked in all versions up through 2003, and others that had features new to Access 2000 or Access XP (2002) that also work […]