image data in query

E

Eugene

Hi,

can anybody tell if there is a way to display an image
within query results?

If yes, then does my function look good:
---------------------------------------
Public Function GetEEPicture(EmployeeID as String)
Dim OP as Image
OP.Picture=LoadPicture("C:\Users\" & EmployeeID & ".jpg")
GetEEPicture=OP.Picture
End Function
---------------------------------------
P.S. But I always get error #91 - "Object variable or
With block variable not set"

Appreciate your help,

Eugene.
 
E

Eugene

Sorry,

there's no need to answer this post now, because, since
as I have discovered, MS Access Image object doesn't
support JPEG format.

Thx.
 
E

Exponent

It does with the relevant graphics filters installed.
--
_______________________________________________________
http://www.ammara.com/
Image Handling Components, Samples, Solutions and Info
DBPix 2.0 - lossless jpeg rotation, EXIF, asynchronous



Eugene said:
Sorry,

there's no need to answer this post now, because, since
as I have discovered, MS Access Image object doesn't
support JPEG format.

Thx.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My macro doesn't work if sheet is protected but it works if not protected 2
Problem Loading and sizing images 3
code to rename image files from query 1
Update File Location Where Images will be Stored from a Query 8
Using Object & Worksheet names as variables 1
How use the GlueTo Method with 2D Shapes 0
How to have an empty image if there is no filepath stored for it 0
Finding and displaying images on a report? 14

Top