Pictures and continuous form

[Colby]

Thanks for reading another one...

I am building an application for my marketing dept. that will track their mailouts. So far I can handle it; however, they want a thumbnail displayed of each piece of creative. I can do this if they only wanted to see one record at a time, but they want all records w/in a certain date range and the pic that goes with it. I am currently storing the path to the image so not to gorge my db to explosion.

pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces

where pic is the thumbnail. I have built it with a continuous form so I can display all the records but I am up to change if needed.
I have read other posts and they all deal with single forms and the onCurrent event is not really working for me.

Any and all help is greatly appreciated!

 

[Oldsoftboss]

It's an Access bug. In a continious form all the images will display the image that is the current record. Sorry

 

[Colby]

Thanks - kind of what I was afraid of since all the posts stayed away from the continuous form.
Is there any other approach someone can think of that would display data and pics at the same time??

Thanks,
Colby

 

[Simon_MT]

There is less than elegant way to get around this.

Double Click on a record and bring up an image Dialogue box Relating to the Current Record.

 

[The_Doc_Man]

Oldsoft, that's not a bug, it's a feature...

 

[Simon_MT]

I might add if you have a datasheet view, with rows of information, double clicking the record will also retrieve the Image Dialogue Form.

 

[Oldsoftboss]

Oldsoft, that's not a bug, it's a feature...

Oops, my bad

 

[micks55]

There is a way... sort of.
1) Create a single form that looks like a continuous one with no bound controls.
2) Add some (5 or so) unbound image controls and any other unbound controls you want.
3) Use DoCmd.GoToControl to skip forward loading the images (remember to use "If Not IsNull(ImageID)" or you'll get error)
4) Use DoCmd.GoToControl to skip back ("On Error Resume Next" can stop error at first record)
Totally ugly, not cool but it's a start. I'm useless so can any of you clever guys please make it error free and elegant?
It's probably rubbish but I made a 9 box image viewer with right and left scroll buttons showing 3 changes at a time.
Mick

 

[Colby]

Thanks!! I will run thru these and see if I can piece something together. I have not touched this post for some time; but...
if I can get it working with the suggestions I will try and post in the example section.

Thanks,
Colby

 

[micks55]

Colby
Let me know how it goes. Shout if you want my example.
Mick

 

[Colby]

micks55 - Definitely send me your example. That will give me more substance to try and muddle my way thru this. You can post it here or send it to me
at michaeldotcolbyatchartercomdotcom. I think you will have to change the file extension so my border patrol wont block it.

thanks