How to shrink up the blank spaces on reports. Q: Randy writes: “I was wondering if there was any way I could shrink up the blank spaces on a report. The CanShrink Property just kinda shifts the blank spaces from the bottom of the detail section to the top in each group of records. I […]
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]”, […]