How to display correct picture in Continuous Form

[ser004]

I created a form and used an image control with a filepathfield that is stored in my table,... that works well as far as displaying the correct picture for each record...

I created a database using "Access 2003"

I now want to create a Continuous Form with the correct image displayed for each row or each record.

The problem is all of the images are displaying the same picture, but i want them to show their correct pictures... I used an "on current" event which i guess is why that is happening cause all the pictures change when different record selectors are clicked.

Please advise how i could get around this... I would like to use the filePath field that i have in my database, since I have to display over 10,000+ photos - using the OLE objects will make the database too big...

Any Ideas? Thanks in Advance

Ser004

 

[John Big Booty]

There is some discussion of this subject in this thread.

 

[ser004]

Thanks for the information (link). Very interesting read...

Until I buy a new Version of Access - I decided to change my forms to "Single Form" vs "Continuous Form" - I'm satisfied for now - all my pictures are shown for each record and the database is much faster.

Thanks again for your help!!!

Ser004

 

[narender]

I created a form and used an image control with a filepathfield that is stored in my table,... that works well as far as displaying the correct picture for each record...

I created a database using "Access 2003"

I now want to create a Continuous Form with the correct image displayed for each row or each record.

The problem is all of the images are displaying the same picture, but i want them to show their correct pictures... I used an "on current" event which i guess is why that is happening cause all the pictures change when different record selectors are clicked.

Please advise how i could get around this... I would like to use the filePath field that i have in my database, since I have to display over 10,000+ photos - using the OLE objects will make the database too big...

Any Ideas? Thanks in Advance

Ser004

Save Image in Base 64

 

[theDBguy]

Save Image in Base 64

@narender Welcome to AWF! This is an old thread, and it's not a problem anymore in newer versions of Access.

 

[oxicottin]

Here is an example including rotate and expand

 

[LukeAB]

Save Image in Base 64

hi, I tried your attachment - not seem to work?

Here is an example including rotate and expand

hi, works nice for pics as files. How does a person use for files sorted in an Access table or SQL table (Long Text or OLE) ?