MS Access | Foster Solutions (FSI)

Create TXT settings file for VBA apps

June 21, 2014 by tech guys

It’s very useful and easy to use a text file as a settings file for VBA applications. The below code is a function that will open a file called adm_settings.txt in the directory of the application file and loop through it to see if it can find the passed setting.Â If it does, it will …

MS Access Form Error when editing SQL Server tables

May 5, 2013 by tech guys

I have found a frustrating write conflict error while building MS Access forms with linked SQL Server tables. There are issues with not having a Timestamp (RowVersion) field, but I finally stumbled across the culprit that was affected several forms.Â If there is a bit field with null values, you can’t edit the record.Â You …