Adding and subtracting dates. Q: Martin writes: I have these records written in two lines (dates, without separation in the European style (1030)) 051007 051107 I then want to take the dates and subtract the dates from each other and get how much time has passed. An easy task with conform dates but this […]
How to get calculated fields to display zero. Q: Rob Stoker writes: I have a calculated field which is sum([nettprice]*[quantity]) which works ok. However if there is no data then it displays #Error. I have tried the Nz function, and tried the IIf function but I can’t seem to stop it doing it. I would […]
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 […]
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 […]
Access Archon #174 The code that does the work of listing, clearing and copying doc properties is listed below. VBA Code Private Sub cmdCopy_Click() On Error GoTo ErrorHandler Dim cbo As Access.ComboBox Dim intType As Integer Set cbo = Me![cboSelectTableOrQuery] strTemplate = Nz(Me![txtTemplate].Value) strRecordSource = Nz(cbo.Column(0)) […]
