Function LatestVersion() As String Dim dateLatestUpdate As Date dateLatestUpdate = DMax("[Date and Time of Update]", "tblVersioning") Debug.Print DLookup("Version", "tblVersioning", "[Date and Time of Update]=#" & dateLatestUpdate & "#") 'the immediate window shows Null --> which means my dlookup failed 'the value of dateLatestUpdate is 7/2/2013 4:19:10 PM by the way, i got this by printing it to the immediate window 'there is only 1 record in the table tblVersioning End Function
|Link Excel Spreadsheet to Access, not using Transferspreadsheet||5||25|
|Prevent use of Microsoft Office application||9||52|
|Would like Regex to return a string array with no duplicates.||3||26|
|Problem with syntax with TransferDatabase||3||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!