A reader suggests a quick way to re-attach all procedures. Mark Plumpton, responding to the Orphaned Code tip in WAW 4.22, suggests that a quick way to re-attach all procedures is to open the original form’s code module, select all (Ctrl-A), copy (Ctrl-C) and then open the new form’s module and paste (Ctrl-V). You should […]
Some interesting error messages and unhelpful help that readers have come across. Sometimes you get singularly unhelpful help or error messages. Here’s some we and our readers have found recently … William Ferry reports the following weird error message, which occurs whenever he boots his laptop running Win NT Workstation: “The control registers for COM2 […]
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 […]
How to prevent duplicate data entry in different records. Q: Nigel Heremaia wants to prevent users from entering the same data in the FirstName and LastName fields in different records. He is using this code, but it isn’t working: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim FirstName Dim LastName Dim FullName FirstName = DLookup(“[FirstName]”, […]
How to delete duplicates from another table. Q: John Haynes writes: I am trying to set up a standard query to delete duplicates. The tables consist of customers from 2 different companies company I and company N. I need to delete the customers in company I when there is a record in company N. I […]