Several readers responded with their suggestions for determining if a database exists. Thomas Mount responded to my tip on finding out whether a file exists in WAW 6.07, with a more efficient method using the FileSystemObject: Function isFile(FileName as String) as Boolean isFile = _ CreateObject(“Scripting.FileSystemObject”).FileExists(FileName) End Function This method is indeed more […]
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, […]