Dataverse
12 TopicsAccess Releases 7 Issue Fixes in Version 2311 (Released November 25th, 2023)
Our newest round of Access bug fixes was released on November 25th, 2023. In this blog post, we highlight some of the fixed issues that our Access engineers released in the current monthly channel.9.4KViews3likes29CommentsAccess Releases 7 Issue Fixes in Version 2310 (Released October 25th, 2023)
Our newest round of Access bug fixes was released on October 25th, 2023. In this blog post, we highlight some of the fixed issues that our Access engineers released in the current monthly channel. If you see a bug that impacts you, and if you are on the current monthly channel Version 2310, you should have these fixes. Make sure you are on Access Build # 16.0.16924.20106 or greater.4.6KViews2likes4Commentsupdate dataverse table with dataverse primary key results in datatype error
Hi all. I have an annoying issue. I use MS access front end, dataverse backend, I'm using a simple bit of VBA code, to add a new record in a table. This is triggered by clicking a button on a form. Once the new record is created, I then want to add the dataverse primary key of the form to that new record. This all works fine when using numeric access primary keys, but I am trying to start using the dataverse primary keys which I think are string and this is throwing up datamismatch errors. Code: Private Sub AddEndorsement() Dim rs As DAO.Recordset On Error GoTo Errorhandle Set rs = CurrentDb.OpenRecordset("Endorsements") With rs .AddNew !Policies = Me.Policies .Update .MoveLast .Bookmark = .LastModified End With rs.Close Set rs = Nothing Exit Sub Errorhandler: MsgBox "Error #: " & Err.Number & vbCrLf & vbCrLf & Err.Description End Sub the error it throws up when trying to add the record is 3421, data type conversion error so clearly a data mismatch on !policies and me.policies. However from all I can see they are the same data type. I have a text box on the form that shows me.policies (the primary key ) correctly as {343very long code}. When I check the datatype it is 8. However, in VBA debug window the same value is shown as "?????" which is odd. Endorsement.policies stores the foreign key successfully for other records . The data type in dataverse is "Lookup" but I assume underlying it still means string. Any ideas?Solved1.6KViews0likes7Comments