How to document an application in Access. Q: Ashjan Al-Mahmeed would like to know what is the best practice of documenting an application in Access (using the documenter and other tools). A: I recommend Total Access Analyzer, which is available in versions for Access 97, 2000 and 2002. See the FMS Web site. I described […]
A reader wants to know how to create a mask for a credit card. Q: Melody Overstreeet writes: “How do you create a mask for a credit card? I want the last for digits to show and the rest I want to be an *” A: I like to use the expression below in a […]
A reader responds to my tip on wrapping text values in quotes, suggesting a function to streamline it. In response to my tip on wrapping text values in quotes using the Chr$ function, Stuart R Ainsworth contributed a function that streamlines this process (I have modified it slightly, and split it into two functions – […]
A simple breakdown of the rather obscure XOR operator Help topic. The Help topic for the XOr operator starts out rather obscurely by explaining that the operator is used to perform a logical exclusion on two expressions. Then it goes from bad to worse: “If one, and only one, of the expressions evaluates to True, […]
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)) […]