Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|MS Access VBA How To Decompress a Gzip Response From a HTTP Request||4||34|
|MS Access How can I complete my Max, Group by query?||13||25|
|get and set file atrributes||5||12|