|
 |
access thread: Linking Pictures
Message #1 by rwalker@w... on Thu, 24 Jan 2002 16:56:30
|
|
Hi,
I want to link pictures that are save on a hard drive to a form and
report. The picture will be different for each record. Can anyone tell
me how to do that?
Thanks
Message #2 by "Haslett, Andrew" <andrew.haslett@i...> on Fri, 25 Jan 2002 09:10:54 +1030
|
|
Yep.
1) Add the control containing the URL of the image - make it invisible (call
it 'ctrImage_URL')
2) Create an Image control (unbound) - call it 'ctrThe_Image'
3) In the OnPrint event of the DETAIL section add the following code:
If Not IsNull(Me![ctrImage_URL]) Then
Me![ctrThe_Image].Picture = Me![ctrImage_URL]
End If
That should be it!
/Andrew
-----Original Message-----
From: rwalker@w... [mailto:rwalker@w...]
Sent: Friday, 25 January 2002 3:27 AM
To: Access
Subject: [access] Linking Pictures
Hi,
I want to link pictures that are save on a hard drive to a form and
report. The picture will be different for each record. Can anyone tell
me how to do that?
Thanks
Message #3 by "Walker, Renee C." <rwalker@w...> on Thu, 24 Jan 2002 16:50:13 -0600
|
|
Hi,
I don't see the onprint event in the DETAIL section.
-----Original Message-----
From: Haslett, Andrew [mailto:andrew.haslett@i...]
Sent: Thursday, January 24, 2002 4:41 PM
To: Access
Subject: [access] RE: Linking Pictures
Yep.
1) Add the control containing the URL of the image - make it invisible (call
it 'ctrImage_URL')
2) Create an Image control (unbound) - call it 'ctrThe_Image'
3) In the OnPrint event of the DETAIL section add the following code:
If Not IsNull(Me![ctrImage_URL]) Then
Me![ctrThe_Image].Picture = Me![ctrImage_URL]
End If
That should be it!
/Andrew
-----Original Message-----
From: rwalker@w... [mailto:rwalker@w...]
Sent: Friday, 25 January 2002 3:27 AM
To: Access
Subject: [access] Linking Pictures
Hi,
I want to link pictures that are save on a hard drive to a form and
report. The picture will be different for each record. Can anyone tell
me how to do that?
Thanks
Message #4 by "Haslett, Andrew" <andrew.haslett@i...> on Fri, 25 Jan 2002 16:47:39 +1030
|
|
In a report, if you double click the 'Detail' bar (header), there is an 'On
Print' event on the 'Events' tab of the properties box...
With a form you'll need to use one of the form's events - perhaps 'On Load',
'On Open' or 'On Got Focus' ?? Not sure, I've never tried it.
A
-----Original Message-----
From: Walker, Renee C. [mailto:rwalker@w...]
Sent: Friday, 25 January 2002 9:20 AM
To: Access
Subject: [access] RE: Linking Pictures
Hi,
I don't see the onprint event in the DETAIL section.
-----Original Message-----
From: Haslett, Andrew [mailto:andrew.haslett@i...]
Sent: Thursday, January 24, 2002 4:41 PM
To: Access
Subject: [access] RE: Linking Pictures
Yep.
1) Add the control containing the URL of the image - make it invisible (call
it 'ctrImage_URL')
2) Create an Image control (unbound) - call it 'ctrThe_Image'
3) In the OnPrint event of the DETAIL section add the following code:
If Not IsNull(Me![ctrImage_URL]) Then
Me![ctrThe_Image].Picture = Me![ctrImage_URL]
End If
That should be it!
/Andrew
-----Original Message-----
From: rwalker@w... [mailto:rwalker@w...]
Sent: Friday, 25 January 2002 3:27 AM
To: Access
Subject: [access] Linking Pictures
Hi,
I want to link pictures that are save on a hard drive to a form and
report. The picture will be different for each record. Can anyone tell
me how to do that?
Thanks
|
|
|
View Cart
