by Carl Connett | May 15, 2009 | Data Type Functions, Loops, Microsoft Access, String Functions, VBA
This VBA function uses the Randomize() and Rnd() functions to generate a random string of characters with a specific length. The included Microsoft Access example applies the function to a simple form that can be used to create a password. When the MS Access database...
by Carl Connett | Apr 27, 2009 | Data Type Functions, Date, Time, and Age Functions, String Functions, VBA
This VBA procedure converts a number, in yyyymmdd format, to a regular date like mm/dd/yyyy. For example, a number like 20090427 will get converted to 4/27/2009. Code: Public Function DateFromNumber(DateNumber) ' This function returns a date from the DateNumber...
by Carl Connett | Mar 10, 2009 | Data Type Functions, Microsoft Access, VBA
Need to get a count of the number of columns in the results of a MS Access query that are not Null? This VBA code will do it. Code: Public Function CountValues(Val1, Val2, Val3, Val4, Val5, Val6) As Integer ' This function passes back the...
