Image problem

[alpapak]

hi

i have a form with the fields
PhotoID
PhotoName
PHotoPath
PhotoDate
PhotoSize
ImageFrame

my Imageframe is showing the image
image format .jpg and size 200kb each

Problem

when i click next record , my mouse is flashing and my db is freezing for 2sec.
I have place a code by www.mvps.org which hide the insert dialog message.
Also , i have change the registry to No (read the article at the www.mvps.org).

I need something that will make my photo to load faster.

thxs
__________________
Alexandros

 

[1eye1vision]

Image size

Hi,
What size image are you using for the Photo ID, this may have a large imapact on the speed in which your photo shows.

Best Regards

1E1V

 

[alpapak]

thx for the reply

the format is .jpg and the size is between max. 250 - min 100 KB

the mouse flash like twice .
it looks like when the image is loading, but two times.
the problem is that it slow down my db . When i moved to the next record and move on.

I have a main form with tabs on it .
Tab 1 is my customers page
Tab 2 is the financial
Tab 3 is the images

Is it possible to load image when i focus on the Tab 3???

 

[1eye1vision]

Store Path Not Image

Hi to be quite honest the best thing to do is always store the PATH to the file in the db, not the file itself. You can then look up the path and let your client computers open the files with their own applications.

To look up the path you could use

dim path as string
path = CurrentProject.path & "\photo\"
With Application.FileSearch
.NewSearch
.FileName = RegNo & ".jpg"
.LookIn = path
.Execute
If .FoundFiles.Count = 1 Then
Me.cmdphoto.Picture = path & RegNo & ".jpg"
Else
Me.cmdphoto.Picture = path & "0.jpg"
End If
End With

This will stop the DB from slowing to much.

 

[alpapak]

thxs for the reply

i have a table with

tblImages
ImagesID
CustomersID
ImagesPath

as you can see , i store the path/name of the file.

Today , i show something else.
if i change the registry = Yes and function disable , the db is crashing when i move to next record fast(the image dialog is the problem i think because it freeze)

any idea???
Since i have the path/name of the image , why it takes so long to load on my form???

 

[1eye1vision]

Path

What i meant by having the path, was not actually show the image but let the user browse to the image and view in a application of their choice that way you don't have to store the image from within access