Access and Photos

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leonard - 15 Jan 2007 05:40 GMT

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

Reply to this Message

Jesper - 15 Jan 2007 23:28 GMT

> 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

Reply to this Message

Leonard - 16 Jan 2007 04:40 GMT

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

> > Is there a way to stop the user going to the next record until the current
> > photo is displayed?
[quoted text clipped - 3 lines]
>
> / Jesper

Reply to this Message

Jesper - 16 Jan 2007 16:27 GMT

>> > 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.

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

Reply to this Message