Hi,
We have an enterprise license for Office 365 does not allow for virtualization. I am using the 2016 Access engine which is freely distributed by MS. When installed locally everything works fine.
On one particular form this code in a control does not work:
=IIf((IsNull(Forms![Contracts Tabbed]![date completed])) And (Forms![Contracts Tabbed]![date contract routed]<>IsNull(Forms![Contracts Tabbed]![date contract routed])),"Routing"," ")
This code does:
Private Sub Command35_Click()
Dim stDocName As String
Dim stLinkCriteria As String
Dim dtFieldValue As Date
Dim varHold As Variant
stDocName = "Contracts Tabbed Read Only2"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.GoToRecord acDataForm, "Contracts Tabbed Read Only2", acGoTo, 10
dtFieldValue = Forms![Contracts Tabbed Read Only2].[Current Term Exp]
varHold = IIf(dtFieldValue < Date, dtFieldValue, "false")
MsgBox varHold
End Sub
Also even if a text box control is formatted short date the displayed date follows the database data not the formatting in the form.
I do not know about how Windows itself is virtualized (I do know it is licensed).
I think that lays it out but let me know if I missed anything.