Access and Photos

[Leonard]

Hi

I have a form that displays a photo for each student. This is done through
storing the path of the photo in a table and displaying the photo when on
current (ie)

me.imgName.picture=me.imgpath

Each photo is downsized to about 7kb so all works well unless a user keeps
pressing the next record button. In some cases this causes access to crash as
it can't keep up with opening the photos to the current record.

Is there a way to stop the user going to the next record until the current
photo is displayed?

Many thanks

Leonard
Australia

 

[Jesper]

Is there a way to stop the user going to the next record until the current

photo is displayed?

A way is to use your own buttons for Next, Previous etc. and then disable
them very briefly until the image i loaded and reenable them then.

/ Jesper

 

[Leonard]

Hi Jesper

Thanks for that. The next and previous buttons are ones I made. How do I
tell if Access is finished loading the photo?

Thanks

Leonard
Australia

 

[Jesper]

Is there a way to stop the user going to the next record until the
I think I've used this on the click events of the next and prev. buttons:
(note that you'll have to move focus somewhere while the button is
disabled).

Me!cmdNextButton.enabled=false
Me!cmdPreviousButton.enabled=false

Me!yourimagecontrol.picture = pathtoimage

Me!cmdNextButton.enabled=true
Me!cmdPreviousButton.enabled=true

would that work?

/ Jesper