This may give some ideas:
I had a similar situation which is working well in
Access. I scanned JPEGs of all my products and opened a field in my
product table called ProductPicture. The value of each field
corresponds to
an address in another folder on my server that holds all the JPEGS.
My address field for say my product 7961776 is stored on a Linux
server
having a common folder and a sub-folder named
productJPGs. So my field in my access table has this value to look up:
\\LinuxMain\Com mon\productJPGs \7961776.jpg
In my report, which can be printed as a product spec
sheet or emailed, the formatting routine (in the code for the report)
links the jpeg at the time of printing or emailing. It gets its value
from the form where I choose a product from a combo box.
'on format jpeg is referenced
Private Sub Detail_Format(C ancel As Integer,
FormatCount As Integer)
On Error Resume Next
Me![ProductImage].Picture =
[Forms]![ProdDispScreen]![ProdID]
End Sub
My print button on my ProdDispScreen form has the
following code:
Private Sub printSpecs_Clic k()
'Prints Product Specifications of ProdID shown in ProdDispScreen.
On Error GoTo Err_printSpecs_ Click
Dim stDocName As String
stDocName = "TagSpecRep "
DoCmd.OpenRepor t stDocName, acPreview,
"TagSpecFil ter"
DoCmd.RunComman d acCmdZoom50
Exit_printSpecs _Click:
Exit Sub
Err_printSpecs_ Click:
MsgBox err.Description
Resume Exit_printSpecs _Click
End Sub
the "TagSpecFil ter" is a query that simply tells it to
print a report
only for the displayed record (product). SQL:
SELECT DISTINCTROW ProdID.*
FROM VFProducts
WHERE
(((Products.Pro dID)=[Forms]![ProdDispScreen]![ProdID]));
In summary, placing all the actual jpeg files in a separate folder
from my actual Access Application improves the performance. I
originally placed the jpegs themselves into my database, but the
loading time and size of my app was unbelievable. Hope this helps a
little!
hth
Brian
"Starwood" <st******@one.n et> wrote in message news:<vm******* *****@corp.supe rnews.com>...
After getting around a problem with the Norton utilities, I have finally
been able to get .jpg images linked to my table. When I try to display the
images using a form, the form presents icons which, when selected, will then
display the image.
Is it possible to get the actual images (they are small thumbnails) to
appear on the form without having to deal with this icon?
George