Morning all, on my recent form, I am getting 2 errors when running the code.
vba below -
Access front end - SQL Server back end.
Me.chkApproved = true is a tick box in Access, Bit field in SQL Server, Default value is set as "0" but shows in SQL Server as ((0)). I get the error saying that the data has changed Error -2147352567 but when i progress through the VBA line by line - it appears to work.
Me.Approved_By = Get long name gives me the cannot assign a value to this field. Again - seems to work when progressing line by line, but when running automatically after press of a button it fails.
I have a timestamp on the table, and the table has been relinked.
vba below -
Access front end - SQL Server back end.
Me.chkApproved = true is a tick box in Access, Bit field in SQL Server, Default value is set as "0" but shows in SQL Server as ((0)). I get the error saying that the data has changed Error -2147352567 but when i progress through the VBA line by line - it appears to work.
Me.Approved_By = Get long name gives me the cannot assign a value to this field. Again - seems to work when progressing line by line, but when running automatically after press of a button it fails.
I have a timestamp on the table, and the table has been relinked.
Code:
Me.chkApproved = True
me.Approved_By = GetLongName