My database contains fields with images, word docs and PDF´s. As a result some of the fields contain a number of different such objects.
I had exactly the same problem and have managed to come up with a solution. It may be not be the slickest ever programming as I am new to Vbscript. Basically when you save a record the macro reads the image field and writes the contents into a text field(s). There is also a mechanism to remove the text when a file is deleted. If you want some more info or screenshots, let me have your e-mail.
count = 1
For Each img In ActiveRecord.Images
If count = 1 then Fields("TECH_NOTE1_TEXT").Text="1) " & MyFile
count = count + 1
If Fields("TECH_NOTE1") = "" Then
If count = 2 then
If count = 3 then
If count = 4 then
My question then is: What is the reason to store in this case more than one object into an image field?
I do that b.e. with Outlook email. Every email is separate saved as msg file an read into an image field (by a script of course). The body text as well as to, cc, bcc, subject + name of attachments are stored in Cardbox text fields. One click an the msg is back on screen again (and if needed with a second click back into your Outlook environment).
Bert thank you. Not even sideways thinking. What comes to mind is I couldn´t see the wood for the trees.
|© 2010 Cardbox Software Limited|