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 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 […]
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 […]
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 […]
Access Archon #162 Getting around Vista Security We have all seen those ads where the Mac guy acts superior to the PC guy who is constantly bothered by the Vista Secret Service agent asking if he wants to cancel or continue every time he tries to do something on his computer. Unfortunately, that ad is […]
