A reader’s having some problems backing up back end databases. Q: Bob Linthicum writes that he is having a problem with backing up back end databases using the code from Access Archon #151. He is getting Error 76, “Path not found”. A: Try my new Extras Plus add-in (Code Sample #20), which updates the backup […]
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 […]
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 […]
