Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-10-2012, 09:19 AM   #1
PaulA
Newly Registered User
 
Join Date: Jul 2001
Location: Philadelphia, PA
Posts: 416
Thanks: 10
Thanked 0 Times in 0 Posts
PaulA
Displaying changing images on a continuous form

Hi, all--

I am in a situation where bmp images are not being displayed on a continuous form when stored in an OLE Object field, supposedly because of a problem with Windows 7.

To work around, I am trying to display the images as an image using the technique from this link:

http://support.microsoft.com/kb/285820

It works for the first record but the image stays the same for all subsequent records in the continous form. If I click on a subsequent record, the image will change to the appropriate one--but so will the images for all other records.

This is resolved for a report based on the same data--the report prints fine using "Detail_Print" sub. But not for continuous forms.

Can anyone find a way of displaying a changing BMP image in a continuous form when the OLE process does not work?

Thanks!

PaulA is offline   Reply With Quote
Old 05-10-2012, 01:22 PM   #2
Simon_MT
Newly Registered User
 
Join Date: Feb 2007
Location: United Kingdom
Posts: 2,177
Thanks: 2
Thanked 162 Times in 158 Posts
Simon_MT has a spectacular aura about Simon_MT has a spectacular aura about
Re: Displaying changing images on a continuous form

What version of Access are you using. Access 2007 finally caters for images in Continuous forms.

Simon
Simon_MT is offline   Reply With Quote
Old 05-11-2012, 05:07 AM   #3
PaulA
Newly Registered User
 
Join Date: Jul 2001
Location: Philadelphia, PA
Posts: 416
Thanks: 10
Thanked 0 Times in 0 Posts
PaulA
Re: Displaying changing images on a continuous form

Thanks for your post.

I'm using a database developed in 2007 but saved as a 2003 mdb to retain user level security. It is used in a 2007 environment.

PaulA is offline   Reply With Quote
Old 05-11-2012, 06:11 AM   #4
Simon_MT
Newly Registered User
 
Join Date: Feb 2007
Location: United Kingdom
Posts: 2,177
Thanks: 2
Thanked 162 Times in 158 Posts
Simon_MT has a spectacular aura about Simon_MT has a spectacular aura about
Re: Displaying changing images on a continuous form

Then I doubt you can put images on a Continuous Form in Access 2003 because the images duplicate themselves, crazy as it seems it wasn't until 2007 that this was remedied.

Simon
Simon_MT is offline   Reply With Quote
Old 05-11-2012, 06:15 AM   #5
PaulA
Newly Registered User
 
Join Date: Jul 2001
Location: Philadelphia, PA
Posts: 416
Thanks: 10
Thanked 0 Times in 0 Posts
PaulA
Re: Displaying changing images on a continuous form

Even if used in 2007 environment?

Basically the only reason that this is any issue is that a group of my users aren't able to view bitmap images the a OLE server. I'm hearing that this is because they use Windows 7 (it works fine for me in Windows XP).

It seems that Microsoft is making what should be simple quite difficult!!!

Thanks.
PaulA is offline   Reply With Quote
Old 05-11-2012, 06:22 AM   #6
Simon_MT
Newly Registered User
 
Join Date: Feb 2007
Location: United Kingdom
Posts: 2,177
Thanks: 2
Thanked 162 Times in 158 Posts
Simon_MT has a spectacular aura about Simon_MT has a spectacular aura about
Re: Displaying changing images on a continuous form

You could look at Refernece Module > Tools > References and check your XP system verses the Windows 7. I have OLE Automation Ticked. I use just the ImageControl and don't have any problems with most image formats jpegs, gifs, or pngs and the one bitmap.

Simon
Simon_MT is offline   Reply With Quote
Old 05-11-2012, 08:54 AM   #7
PaulA
Newly Registered User
 
Join Date: Jul 2001
Location: Philadelphia, PA
Posts: 416
Thanks: 10
Thanked 0 Times in 0 Posts
PaulA
Re: Displaying changing images on a continuous form

Thanks for the suggestion.

I checked a couple of places and I'm not finding what you are referring to. Where do I find the reference module?

PaulA is offline   Reply With Quote
Old 05-11-2012, 09:11 AM   #8
Simon_MT
Newly Registered User
 
Join Date: Feb 2007
Location: United Kingdom
Posts: 2,177
Thanks: 2
Thanked 162 Times in 158 Posts
Simon_MT has a spectacular aura about Simon_MT has a spectacular aura about
Re: Displaying changing images on a continuous form

In a Module or a Sub on a Form

Simon
Simon_MT is offline   Reply With Quote
Old 05-11-2012, 09:20 AM   #9
PaulA
Newly Registered User
 
Join Date: Jul 2001
Location: Philadelphia, PA
Posts: 416
Thanks: 10
Thanked 0 Times in 0 Posts
PaulA
Re: Displaying changing images on a continuous form

Thanks for your help. I'll check it out.
PaulA is offline   Reply With Quote
Old 05-11-2012, 10:40 AM   #10
PaulA
Newly Registered User
 
Join Date: Jul 2001
Location: Philadelphia, PA
Posts: 416
Thanks: 10
Thanked 0 Times in 0 Posts
PaulA
Re: Displaying changing images on a continuous form

I have actually discovered that the Access 2007 functioning of images in continuous forms works even when reading a 2003 database through Access 2007.

This is a great finding and solves my problem.

Thanks for your input.
PaulA is offline   Reply With Quote
Old 05-11-2012, 10:49 AM   #11
Simon_MT
Newly Registered User
 
Join Date: Feb 2007
Location: United Kingdom
Posts: 2,177
Thanks: 2
Thanked 162 Times in 158 Posts
Simon_MT has a spectacular aura about Simon_MT has a spectacular aura about
Re: Displaying changing images on a continuous form

This was a major change in Access 2007, I went from Access 97 to Access 2007 simply because this feature was included. If the Front End is Access 2007 then it does not matter if the backend is 2003.

Simon

Simon_MT is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying Web Images in Form Ray Stantz Forms 1 12-02-2009 01:52 PM
Display images on a continuous form D.W. Schingenga Modules & VBA 0 10-04-2007 04:16 AM
[SOLVED] Displaying Images in a Form connellr Forms 2 11-11-2003 12:51 AM
Images in continuous form mchow Forms 2 06-24-2003 02:36 AM
[SOLVED] Dealing images in Access 2000 continuous form sldung Forms 0 12-10-2001 10:30 AM




All times are GMT -8. The time now is 11:35 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World