How to add and delete listbox items, and how to get the most out of the AddItem and RemoveItem methods. Access Archon #172 Introduction About six years ago, I wrote two Access Archon articles on working with listboxes, adding and deleting items from the lists. I used tables as the listboxes’ row source, with […]
How to find Outlook mail messages from a specific sender. Q: Ray in New Zealand writes: “I’m trying to link my Access db (Accommodation) to Outlook. I receive accommodation bookings from guests and would like to be able to click on a button on the guest data form which will take me to the emails […]
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 […]
Q: Mark Jackson writes that he is having trouble getting code that picks up values from textboxes on a form to work – a Help topic said that the focus must be on the control in order to pick up the topic. A: Some of those Help topics are very old. You don’t need to […]
How to stop Access auto-correcting your typing when you don’t want it to. Q: Maryann S. writes: “My application uses a number of two- or three-letter codes as field values. Sometimes, when I type one in, it changes to something else (for example, HGE changes to HE). How can I stop this? It is really […]
