Solved Image Object in Continuous Forms

[TipsyWolf]

hey guys,
it didn't take long until i face with another problem for me lol

i have a Continuous Forms and Attachment as field type, but now im in a process of switching to storing pic outside of db.

so im gonna need to remove attachments soon and .... my Image Object type which does its job perfectly - can't be more happier, but i dont know who to link Image Object type (which it gets image from link stored in "picbefore1filepath" field

i set its Control Source in Image Object as

="[picbefore1filepath]= " & [RiskID]
="[RiskID]= " & [picbefore1filepath]

surly both options didn't work for me.

please help

 

[TipsyWolf]

as u can see
"RiskID" is always = "picbefore1filepath" as they are basically in one table

 

[theDBguy]

In the control source of the image, simply select the filepath field from the dropdown.

 

[TipsyWolf]

In the control source of the image, simply select the filepath field from the dropdown.

i had it. it shows like there is no pictures

Tmain Tmain

RiskID	RiskCode	riskTitle	isActive	RiskdueDate	RiskDate	locationID	location	locationPricies	risktype	riskcolor	reporter	picafter	picbefore	picbefore1filepath	picbefore1picname	picbefore2filepath	picbefore2picname	picbefore3filepath	picbefore3picname	picafter1filepath	picafter1picname	picafter2filepath	picafter2picname	picafter3filepath	picafter3picname
460​	15​	XXX	No​	​	20.06.2024​	0​	XXX	XXX	XXX		XXX	0	2	C:\Images\RiskID_460_before_1.jpg	RiskID_460_before_1.jpg					C:\Images\RiskID_460_after_1.jpg	RiskID_460_after_1.jpg

 

[theDBguy]

What are the values stored in that field?

 

[MajP]

To be clear you are using an "Image Control" not another type of object frame?
The control source is set in the property window to "picBefore1FilePath"?

 

[TipsyWolf]

What are the values stored in that field?

links to pictures
C:\Images\RiskID_460_before_1.jpg

my form shows them perfectly like in this case
ID 460. 2 pictures.

 

[TipsyWolf]

To be clear you are using an "Image Control" not another type of object frame?

its "Image"

here its property sheet.

The control source is set in the property window to "picBefore1FilePath"?

yeah. "picBefore1FilePath" filed has a link to certain picture.

it works in form, but it doesn't in Continuous Form. .... hm...

 

[MajP]

it works in form, but it doesn't in Continuous Form. .... hm...

If it works in single form view and not in continuous form view.
I would delete the image control and re-add it. Maybe it is a formatting issue on the control. Looks like you have it correct.

 

[TipsyWolf]

guys , figured it out by myself !!! its a win for me !
the reason why it didn't show any pic is ... i didn't include new added fields into Records Source of this Continuous Forms.
once i added - it shown the picture !

im glad im learning something at least. not the way i should , but anyway.
thank you guys !

 

[Gasman]

Don't feel so bad.A user on another forum was trying to requery and set focus to a form.
Nothing wrong with that you might say?

Problem was, the form was not open.

 

[TipsyWolf]

Problem was, the form was not open.

ahah LOL