Freen

Hi, can't recall the reasons behind it, but your're able to edit the MEMO field only using that field in a Form.

In the sample demoattachment.nsb, pictures are stored inside this database. Storing pictures inside a database will make the database file very large, is it also possible to display pictures (or a thumbnail of them) inside a database by only linking them from a separate folder? I would like to integrate a similar function into the assets database, to have pictures of assets, but I worry that the database will get too large very quickly.

Are there any provisions to encrypt the database? Password protection? User login?

In the form, there is currently the function for the date formatting on edtNextSchedMaint. I don't want the date formatting to happen, if the asset is inactive.

How can I get other items on the form to ignore their formatting, based on the status? I've tried a nested approach, but get an error message. I guess it is not that easy to add an additional condition. local status=string.lower(self.dataset.getFieldname("id_Status")) if status=="Inactive" or status=="Sold" then local color="clNone" elseif local now=date() local nextSchedMaint=date(self.getProperty('edtNextSchedMaint.luadate')) local delta=now:spandays()-nextSchedMaint:spandays() local color='clNone'...

I'm trying to get a formatting condition to work, using your original date code for edtNextSchedMaint, but its not going so well. My thinking is too linear -_-. I want to highlight edtDescription and edtid in red, showing that the Asset is no longer in service, using the status of cbxStatus. Of course I get error messages as I don't understand the function correctly. local self.getProperty('cbxStatus.text') local color='clNone' if text= "Inactive" then color='clRed' elseif text='Sold' then color='clRed'...

That worked :-) I also managed to add the comma before the space, which is why I looked at that code in the first place. Thank you

There seems to be a problem with field edtSalvageValue in form Assets. It is not possible to enter decimal value amounts, for example £ 10.55 or 10,05 € - it either produces an error or the amount entered is incorrect. What could be the reason for this strange behavior? - And I somehow broke this code in view frmAssets_cbxEmployees? - I only copied and pasted the code, but now I'm getting getting error message: ScriptError [nsbaselists] at line 47: SQL Error: SQL logic error: unrecognized token:...