By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Help needed on picture files in access

P: n/a
I need to include a picture / photograph in a Db then from a query
export to Excel - picture included - I just can't find a way through
this - can anyone please help? TIA JOhn

Jan 9 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
This may help, but it reports a product spec sheet directly from an
actual Access reort rather than exporting to excel. Describe the
specifics of why you need to export images to excel - the processing
overhead could be pretty high.

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\Common\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(Cancel 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_Click()
'Prints Product Specifications of ProdID shown in ProdDispScreen.
On Error GoTo Err_printSpecs_Click
Dim stDocName As String
stDocName = "TagSpecRep"
DoCmd.OpenReport stDocName, acPreview,
"TagSpecFilter"
DoCmd.RunCommand acCmdZoom50
Exit_printSpecs_Click:
Exit Sub
Err_printSpecs_Click:
MsgBox err.Description
Resume Exit_printSpecs_Click
End Sub
the "TagSpecFilter" 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.ProdID)=[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! Brian

Jan 9 '06 #2

P: n/a
Brian

Many thanks for taling the time to repond to my request.

I am not a techie so I am still working through your code and looking
at adapting it for my need. But I do understand the concept and I
believe it will solve my problem.

My need is driven by the following. I currently use Access 97 to
produce my html web pages from queries. This works well but is all
descriptive without any pictures but I do carry a simple PICTURE
hyperlink to the specific picture for that product.

Willing to accept constructive critism I am responding to clients who
say they would like to see a thumbnail of each item - I am loathed to
give up the system I use so am looking for a solution work-arround. I
will battle on with your code but if you can add anything to help my
quest I would appreciate it.

many Thanks - John - www.gamesetal.net

Jan 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.