Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-20-2019, 07:45 AM   #1
Digi
Newly Registered User
 
Join Date: May 2019
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
Digi is on a distinguished road
Changing images on a Continuous Form

Hey,

I am not sure if what I am trying to do is even possible after some research on it however here goes.

I have created comment log database where the user fills in a form and selects a button to rate the customers mood, 1 to 5. Each button has a custom image on it angry to happy. The information is stored in the table as the number 1 to 5 based on which button was selected.

I then have a coninuous form that shows info from this table as a quick reference with a button to open up a much more detailed view of the customer info, however rather than show the number 1 to 5 of the customers mood I want to show the custom image again.

I've tried all sorts and come up against the issues that a continuous form is infact just one form therefore a change to one is reflected in all, but is there another way I can solve this?

Thanks in advance.

Digi is offline   Reply With Quote
Old 07-20-2019, 08:05 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,947
Thanks: 57
Thanked 1,297 Times in 1,278 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Changing images on a Continuous Form

Hi. Yes. This should not be a problem if you store the image externally to the database and simply store the path to the images. You can then bind the image control to it and no code is needed.
__________________
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.

Last edited by theDBguy; 07-20-2019 at 08:31 AM.
theDBguy is offline   Reply With Quote
Old 07-20-2019, 08:15 AM   #3
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Changing images on a Continuous Form

what is the fieldtype of your custom images. OLE (blob) or attachment?

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 07-20-2019, 08:26 AM   #4
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 1,000
Thanks: 72
Thanked 49 Times in 42 Posts
MickJav will become famous soon enough
Re: Changing images on a Continuous Form

I do this a lot


If Not IsNull(Me![Picture]) Then
Me.Imgage1.Picture = Me![FoldersLoc] & Me![Picture]
Me![CmdRemove1].Enabled = True
End If


Imgage1 has its picture type set to linked
Me![FoldersLoc] is the loaction of my main storage folders
Me![Picture] is the field in the table holding its name only
Me![FoldersLoc] & Me![Picture] these can be one but if you move the folder you will have to update all linked pictures


If your only going to have a few you could create a table with there names and link then use a combo to select happy, sad Etc
__________________
All open code examples and free projects are only available from:

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


Creating a new project then add styles to it download open code example from:

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

Last edited by MickJav; 07-20-2019 at 08:34 AM.
MickJav is offline   Reply With Quote
Old 07-20-2019, 09:39 AM   #5
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Changing images on a Continuous Form

sample continuous form using images from attachment field.
Attached Files
File Type: zip ImageDatabase.zip (38.2 KB, 8 views)
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 07-23-2019, 04:29 AM   #6
Digi
Newly Registered User
 
Join Date: May 2019
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
Digi is on a distinguished road
Re: Changing images on a Continuous Form

Quote:
Originally Posted by arnelgp View Post
what is the fieldtype of your custom images. OLE (blob) or attachment?
Hey, the field is an attachment.
Digi is offline   Reply With Quote
Old 07-23-2019, 04:33 AM   #7
Digi
Newly Registered User
 
Join Date: May 2019
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
Digi is on a distinguished road
Re: Changing images on a Continuous Form

Quote:
Originally Posted by MickJav View Post
I do this a lot


If Not IsNull(Me![Picture]) Then
Me.Imgage1.Picture = Me![FoldersLoc] & Me![Picture]
Me![CmdRemove1].Enabled = True
End If


Imgage1 has its picture type set to linked
Me![FoldersLoc] is the loaction of my main storage folders
Me![Picture] is the field in the table holding its name only
Me![FoldersLoc] & Me![Picture] these can be one but if you move the folder you will have to update all linked pictures


If your only going to have a few you could create a table with there names and link then use a combo to select happy, sad Etc
Hi, Thanks for the reply.

I am relatively new to all this...

What does the CmdRemove1 refer too? I have tried running this code in the on load of the continuous form and disabled the line referencing the CmdRemove, the image appears that the first record refers too, however this image is then the same for each result regardless of whether the field says angry, sad, neutral etc.

Appreciate your help.

Digi is offline   Reply With Quote
Old 07-23-2019, 06:52 AM   #8
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,947
Thanks: 57
Thanked 1,297 Times in 1,278 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Changing images on a Continuous Form

Quote:
Originally Posted by Digi View Post
Hey, the field is an attachment.
Hi. Just curious, did you try Arnel's demo?
__________________
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 07-23-2019, 10:03 AM   #9
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Changing images on a Continuous Form

here is another example (sample1 form), without using attachment field and instead using external image file.

before opening the db, extract the two images to "C:".
if you open tblNoAttachment table, the column ImagePath points to these images in drive C:

if you must move these images you must update this column to the correct path.
Attached Files
File Type: zip ImageDatabase.zip (71.7 KB, 3 views)

__________________
"Never stop learning, because life never stops teaching"
arnelgp 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
[SOLVED] Using OLE Object for multiple images on a continuous form jjake Forms 21 11-26-2018 02:00 PM
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




All times are GMT -8. The time now is 08:26 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