Data Type Functions Archives

Generate a random set of characters using VBA function Rnd()

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...

Convert a number to a date using VBA

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...

Count non-Null values across columns in a Microsoft Access record

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...

Notes

Some operating systems block files that come from other computers. If you cannot get a downloaded file to work properly, right-click over the file, select the Properties option, and then click the Unblock button at the bottom of the General tab.

Generate a random set of characters using VBA function Rnd()

Convert a number to a date using VBA

Count non-Null values across columns in a Microsoft Access record

Notes

Categories