Error 94 "Incorrect use of Null" in Function "IDbComponent_DbObject"

[monheimx9]

Dear joyfullservice

While exporting all sources

In the class "clsDbSharedImage"
In the Function "IDbComponent_DbObject"
Error 94 on the line:
m_Extension = m_Rst!Extension
"Incorrect use of Null"

Tested on version v3.4.23 and tried on v4.0.13-beta as well
(I took some long programming vacations, the add-in was working perfectly before)
Access Version 2306 Build 16.0.16529.20100 (64Bits)

Here you can find a screenshot of the Immediate Debug Window

"<Opération non autorisée pour ce type d'objet>" means "Operation not authorized for this object type"
"Vrai" means "True"
"Faux" means "False"
"Opération non valide" means "Operation not valid"
Translated from French

If I can provide you additional informations feel free to ask

Otherwise I want to thank you for this amazing addin, I used it a lot last year and provided me great help in my workflow
Cheers

[joyfullservice]

Thanks for reporting this! I have wrapped the field reference in the Nz() function to ensure that we are assigning a string value to m_Extension.

[monheimx9]

Thank you for your answer, I've made the change on my side as well
But might check my comment here f8d1f22#r120797607
I think there is a typo

Wish you a nice day :)

[monheimx9]

Sorry, did not see 6052299
Thus my previous comment is irrelevant

[joyfullservice]

Yes, you are correct. I had some other refactoring I was doing in other commits around the same time. 😄 I am hoping to build an updated beta version in the next few days, which should include this and other fixes.

[joyfullservice]

I believe this has been resolved now. Closing out as completed.