Recent content by smaction

Thank you both. CDATE() works so that puts me on the right path (I think). Still not sure why control value is being converted to string in virtual environment but not non-virtual. I will experiment to Me.Recordset.fieldname to see if that sheds any light on the issue.

Hi Doc, I will try the CDate() solution. What would be the correct way to take the date from the record and not the form? Any idea why this works on local or networked installs but not in virtual? Scott

Sorry Inherited code base. I meant to post this piece: =IIf([Forms]![Contracts Tabbed Read Only2]![Current Term Exp]<Now(),"*Expired*"," ")

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

Pat,. I am not replacing all functionality. Using Horizon they have access to only this application. Not a whole desktop. It is designed to replace the use case where each user had a local installation of Access and opened the FE which connected to a Access db BE. VPN was used to connect...

Thank you both. Now I can get on with testing the underlying problem I am using this code snippet to examine.

I wrote a piece of code to test an issue with an iif() statement. I am getting an unexpected result. The code below displays 3 msg boxes (all with the expected data) instead of 2. What have I forgotten/ missed in this code? Private Sub Command35_Click() Dim stDocName As String Dim...

Does anyone have experience virtualizing an Access database on VMWare's Horizon? I have a Access FE connected to a SQL Server. It works fine with Office 365 version of Access and the Access redistsributable engine. When it is virtualized certain code does not work and formatting within Forms...

I saw you mentioned "-1 is true". In my test code I am getting 1. I thought 0 was false, do you know what 1 is? TIA

I am an experienced developer and have used Access for quite some time, but not recently. I live in Las Vegas, NV and currently work as a programmer. Found this site researching a problem I was having with one database application.