Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-16-2018, 06:32 AM   #1
jjake
Newly Registered User
 
Join Date: Oct 2015
Location: Texas, USA
Posts: 242
Thanks: 60
Thanked 0 Times in 0 Posts
jjake is on a distinguished road
Using OLE Object for multiple images on a continuous form

Hello,

I have a form that allows multiple users to sign an agreement. combo box (cboyesno) choices are

Undecided, Yes, No

I have a continuous form that reviews all the open agreements where all parties have not selected Yes. These are open agreements.

I would like to display a nice custom image that will display either a check image, cross image or blank image depending on the selection in the users cboYesNo.

I tried an OLE object field in the table of tblYesNo and insert the image for each selection and reference them on the continuous form but cannot get the image to appear.

Is this the right approach?

Below is an example of what i want to achieve but obviously the individual records will have different results



Last edited by jjake; 11-16-2018 at 06:49 AM. Reason: Added a Picture
jjake is offline   Reply With Quote
Old 11-16-2018, 07:29 AM   #2
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 5,783
Thanks: 139
Thanked 1,561 Times in 1,533 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: Using OLE Object for multiple images on a continuous form

Did you link the images into your underlying query ?

There is a bar graph / arrow meter demo somewhere that uses this technique. I use it but can't find the original at the moment.

Attached Images
File Type: png BarGraphs.PNG (44.7 KB, 150 views)
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 11-16-2018, 07:39 AM   #3
jjake
Newly Registered User
 
Join Date: Oct 2015
Location: Texas, USA
Posts: 242
Thanks: 60
Thanked 0 Times in 0 Posts
jjake is on a distinguished road
Re: Using OLE Object for multiple images on a continuous form

I embedded them in the table for now because this is a split system with multiple users having a different drive map on their computers, i dont think path linking will work.

jjake is offline   Reply With Quote
Old 11-16-2018, 07:47 AM   #4
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 5,783
Thanks: 139
Thanked 1,561 Times in 1,533 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: Using OLE Object for multiple images on a continuous form

Sorry - I meant to say saved in a local table on the FE, as an OLE Object , which sounds like what you have done. It's not normally a big overhead.

As you can see it does work. So I wonder why yours isn't?
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 11-16-2018, 08:17 AM   #5
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 5,783
Thanks: 139
Thanked 1,561 Times in 1,533 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: Using OLE Object for multiple images on a continuous form

The link for the Dashboard Graphics demo used be based at datapig technologies, but it appears to be dead.
Hitech Coach has a load of links on his site to the same demo, and they are dead as well so I'm assuming the site is down.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 11-16-2018, 03:21 PM   #6
jjake
Newly Registered User
 
Join Date: Oct 2015
Location: Texas, USA
Posts: 242
Thanks: 60
Thanked 0 Times in 0 Posts
jjake is on a distinguished road
Re: Using OLE Object for multiple images on a continuous form

I tried searching for it too but every website wants a credit card. that's too bad, that looks to be exactly what i need.

Would i use an bound object frame in the detail field of my continuous form? How do i link this to my table image?
jjake is offline   Reply With Quote
Old 11-16-2018, 04:41 PM   #7
theDBguy
Newly Registered User
 
theDBguy's Avatar
 
Join Date: Oct 2018
Posts: 207
Thanks: 2
Thanked 32 Times in 31 Posts
theDBguy is on a distinguished road
Re: Using OLE Object for multiple images on a continuous form

Hi,

Rather than an OLE field, I wonder if you could use the image gallery for this but I can’t check right now.

Sent from phone...

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-19-2018, 01:07 AM   #8
AccStudent
Newly Registered User
 
Join Date: Nov 2018
Posts: 4
Thanks: 2
Thanked 0 Times in 0 Posts
AccStudent is on a distinguished road
Re: Using OLE Object for multiple images on a continuous form

Quote:
Originally Posted by jjake View Post
I embedded them in the table for now because this is a split system with multiple users having a different drive map on their computers, i dont think path linking will work.
In my opinion,all of your partners can use a share disk path to save the img.
for example the path like:\\192.168.0.1\img\
and you put images into the folder “img”,and save the path in tblimg
AccStudent is offline   Reply With Quote
Old 11-19-2018, 04:51 AM   #9
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 675
Thanks: 13
Thanked 160 Times in 158 Posts
MajP will become famous soon enough
Re: Using OLE Object for multiple images on a continuous form

Seems like you are making this overly complicated. You only have three images
Quote:
custom image that will display either a check image, cross image or blank image
Distribute the three images with the front end and store in the same folder as the front end. Then use a bound picture control. You know the file name and the path since it is currentproject.path. You will have to bind to a query that concatenates the path and filename base on what you want to show.
MajP is offline   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
jjake (11-26-2018)
Old 11-19-2018, 06:18 AM   #10
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 5,783
Thanks: 139
Thanked 1,561 Times in 1,533 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: Using OLE Object for multiple images on a continuous form

I would have thought three images stored in the table directly for this would be pretty efficient and work without having to store things externally.

I don't understand why it won't display.

Can you post up your sample data and your form?
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
The Following User Says Thank You to Minty For This Useful Post:
jjake (11-26-2018)
Old 11-19-2018, 06:23 AM   #11
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,350
Thanks: 92
Thanked 1,811 Times in 1,686 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: Using OLE Object for multiple images on a continuous form

For a similar situation where I need to use the same images repeatedly, I use the method suggested earlier and store several small images in the image gallery.
It's fast, efficient and has little impact on database size
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 11-19-2018, 07:26 AM   #12
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 675
Thanks: 13
Thanked 160 Times in 158 Posts
MajP will become famous soon enough
Re: Using OLE Object for multiple images on a continuous form

Quote:
I don't understand why it won't display
The likely cause is that the images are not stored as Bitmaps. I believe only bitmaps will render. Other picture types will only show as icons. But yes if the OP uses a bitmap the simple solution is to use an OLE field and it will render in a continuous form.
MajP is offline   Reply With Quote
Old 11-19-2018, 08:10 AM   #13
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,350
Thanks: 92
Thanked 1,811 Times in 1,686 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: Using OLE Object for multiple images on a continuous form

Quote:
Originally Posted by MajP View Post
The likely cause is that the images are not stored as Bitmaps. I believe only bitmaps will render. Other picture types will only show as icons. But yes if the OP uses a bitmap the simple solution is to use an OLE field and it will render in a continuous form.
Using images stored in the image gallery, you can have png, gig, or jpg images all of which render perfectly as images (not icons) on a form.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 11-19-2018, 08:20 AM   #14
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 675
Thanks: 13
Thanked 160 Times in 158 Posts
MajP will become famous soon enough
Re: Using OLE Object for multiple images on a continuous form

Quote:
Using images stored in the image gallery, you can have png, gig, or jpg images all of which render perfectly as images (not icons) on a form
OK, but that was not the question. The question was why the OLE objects were not showing.
Quote:
I tried an OLE object field in the table of tblYesNo and insert the image for each selection and reference them on the continuous form but cannot get the image to appear.
MajP is offline   Reply With Quote
Old 11-19-2018, 08:36 AM   #15
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,350
Thanks: 92
Thanked 1,811 Times in 1,686 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: Using OLE Object for multiple images on a continuous form

Yes but other valid suggestions have since been made for dealing with this situation

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs 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
How to display 10 Images horizontally on a continuous form using vba Exi Forms 25 09-20-2017 10:13 PM
Displaying changing images on a continuous form PaulA Forms 10 05-11-2012 10:49 AM
Display images on a continuous form D.W. Schingenga Modules & VBA 0 10-04-2007 04:16 AM
Images in continuous form mchow Forms 2 06-24-2003 02:36 AM
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 09:12 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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World