Simple question, Im writing a macro that can rename an image, but I need to put this new name of the image on the field it was before at the table, so that I dont lose the link between the image and the table. I have the right adress to the picture on a variable, just wanna know how to put this in the table without having to link the image again using the image control.
Please have a look at the Base Guide, special Base Guide - chapter Macros.
You know the name of the form field? So you could do it by oField.BoundField.updateString("NewPath").
You only know the name of the field in the table?
oForm.updateString(oForm.findColumn("PathToImage"),"NewPath")
You don’t need to link again, as the link goes to the column in your database, when this are filenames.
.
But maybe you gave to refresh the form/row. Depends on your setup. (I have a macro triggered at mouseover to reload, so I need the right name in the form, after edit ).