Enable way apply attachment field value to control.
The attachment field in a table is great for storing custom pix to stay with database even if database is moved to a different computer. I need to make sure lots of custom pix (png, bitmap) go with a database file. Would be fantastic if Pix stored in a table’s attachment field could be used for items like background pix of form, or a pix for an activeX control or a bitmap for use on a command button. And COULD BE Set at runtime what pix in attachment field in a table is applied to what control. Would not mind, much, if had to use DAO to get value of attachment field to do this.
Storing the path would NOT work on a different machine. So please make it possible to get the stored pix in an attachment field in a table assigned to controls like the form as a background image, and another image most likely a bitmap to use on a command button. Being able to use something other than a bitmap pix on a command button would be even better, but could live without being able to use something other than a bitmap on a command button.
Klaus Oberdalhoff commented
> Anonymous commented · September 09, 2016 08:23
> not just put in attachment control
at least as long it is an ACCESS ONLY feature with no (easy) possibillity to use it one to one within a sql server Backend ...
"Storing the path would NOT work on a different machine" why not? Create a subdirectory in the db directory to house your files and copy the whole thing. I VBA you can easily reference such files.
Another alternative is to house them in a table and then at runtime extract them locally to use them as you need.
Either way, there truly is no problem here.
not just put in attachment control.