Search results

Only change I see is the removal of "CDate"

02/02/2014 True 02/02/2015 True 02/03/2014 True Monkeyed with script after last error message and the following seems to work: Do While Len(f) > 0 tmp = Mid(f, 6, 8) 'Debug.Print Format(tmp, "00/00/0000"), IsDate(Format(tmp, "00/00/0000")) dTmp =...

Results are thus: 02022014 False 02032014 False 02022015 False

I get a a Run time Error 13, Type mismatch at this line: dTmp = CDate(Format(tmp, "00/00/0000"))I tried putting "#00/00/0000#" but did not help.

I have a backup directory with the the date in the filenames to mark when a database was backup-ed. I want to search the directory and return the filename with the latest backup date. (Not last modified date) Format looks like this (always) FileName_mmddyyyy.accdb Thus in C:\BackupDbDir...

Actually I got it to work. IIf((Val([FieldName) = 0),(Val([FieldName])+ 9999), Val([FieldName] )) Sorted ascending.

I have data that has numbers, numbers and letters and letters and numbers in a text field. Looks like this 1,1a, 13a, 14a, 15o, PP23, PP23a, 2,44, AB3 Needs to sort like this: 1, 1a, 2, 13a, 14a, 15o, 44, AB3, PP23, PP23a I used the val(fieldname) function in an Access 2010 query field and it...