How to make an pic appear on a form from a table?

[killercrossover]

i have store a pic in a table in access and now im trying to make it appear on the form. think it going to takes some vba code. and i was trying to use a tiff pic to do this with.

Thanks for the help

 

[fumei]

LoadPicture

faq219-2884

Gerry
My paintings and sculpture

 

[killercrossover]

yah think "LoadPicture"

 

[camjon]

try this

forum705: Microsoft: Access Modules (VBA Coding)

 

[fumei]

Yah....I do think. Are you trying to be funny? I am not quite getting it. You use LoadPicture to put an image into a control.

From Help...a reasonably good place to start looking.

Picture Property

Specifies the bitmap to display on an object.

Syntax

object.Picture = LoadPicture( pathname )

The Picture property syntax has these parts:

Part Description
object Required. A valid object.
pathname Required. The full path to a picture file.

Now, 'tis true, this may not be applicable to your situation, but then....you do not actually get explicitly descriptive. "im trying to make it appear on the form. " is rather...shall we say....vague?

Appear? You mean, like magic?

You can make an image (say your TIFF) "appear" by...ummmmm...using an Image control, and......ummmm, LoadPicture.

Again, if that is NOT your situation - you are not using an image control (or any other control that can take an image using.....LoadPicture), then it would help if you actually stated what you are doing.

I notice you have also posted the same question in Access VBA forum. Hopefully you will get an answer that will work for you.

faq219-2884

Gerry
My paintings and sculpture

 

[killercrossover]

thanks for tip but that not going to work there is no file path name for the pics. when you bring up the table you double click on the cell and it opens the pic. so bacily im use the table as a storge for the pics then i want take them and load, appear or whatever you want to call it on or to the form. there is no file a path for the pics.i use OLE Object to store the tiff files that im working with in the table.in facted access renames it to package. keep in mind this is all in access

 

[fumei]

Well that certainly helps in that you clearly state the situation. As this is an Access issue, your post in that forum will likely be the route to getting an answer.

A byte-array? I do not know how your form can show the image without something to hold the image.

faq219-2884

Gerry
My paintings and sculpture