A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

image linked to a report



 
 
Thread Tools Display Modes
  #1  
Old November 20th, 2006, 01:57 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
-DwayneWade
external usenet poster
 
Posts: 4
Default image linked to a report

Hi,

I want to put a image in my report header and I got 20+ reports
have the same header. What is the best way to implement this so that if I
change the image, I don't need to do 20+ times processing? Thanks.


  #2  
Old November 20th, 2006, 02:05 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default image linked to a report

Use a subreport that you can place in the Report Header of your reports.

--
Duane Hookom
MS Access MVP

" -DwayneWade" wrote in message
...
Hi,

I want to put a image in my report header and I got 20+ reports
have the same header. What is the best way to implement this so that if I
change the image, I don't need to do 20+ times processing? Thanks.



  #3  
Old November 20th, 2006, 02:43 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
009SteveJobs
external usenet poster
 
Posts: 3
Default image linked to a report

How do you create a image link to an external file so that whenever I change
the image, it will reflect on the report? Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Use a subreport that you can place in the Report Header of your reports.

--
Duane Hookom
MS Access MVP

" -DwayneWade" wrote in message
...
Hi,

I want to put a image in my report header and I got 20+ reports
have the same header. What is the best way to implement this so that if I
change the image, I don't need to do 20+ times processing? Thanks.





  #4  
Old November 20th, 2006, 03:26 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default image linked to a report

You store the path to your image in a field "ImageName" so the value might
be something like:
"H:\Data\Images\MySnout.jpg"
Add an image control to your report. Add a text box "txtImageName" to your
report's section.
Then in the On Format event of the section of the report containing your
image control, add code like:

If Len(Dir(Me.txtImageName))0 Then
Me.imgControlName.Picture = Me.txtImageName
Me.imgControlName.Visible = True
Else
Me.imgControlName.Visible = False
End If

--
Duane Hookom
MS Access MVP

" 009SteveJobs" wrote in message
...
How do you create a image link to an external file so that whenever I
change the image, it will reflect on the report? Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Use a subreport that you can place in the Report Header of your reports.

--
Duane Hookom
MS Access MVP

" -DwayneWade" wrote in message
...
Hi,

I want to put a image in my report header and I got 20+
reports have the same header. What is the best way to implement this so
that if I change the image, I don't need to do 20+ times processing?
Thanks.







  #5  
Old November 21st, 2006, 03:24 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
-01SteveJobs
external usenet poster
 
Posts: 4
Default image linked to a report

When I add an image control to the report, it automatically asks me for the
image file and then embedded the file. How can I bound it to a field in a
table? THanks.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You store the path to your image in a field "ImageName" so the value might
be something like:
"H:\Data\Images\MySnout.jpg"
Add an image control to your report. Add a text box "txtImageName" to your
report's section.
Then in the On Format event of the section of the report containing your
image control, add code like:

If Len(Dir(Me.txtImageName))0 Then
Me.imgControlName.Picture = Me.txtImageName
Me.imgControlName.Visible = True
Else
Me.imgControlName.Visible = False
End If

--
Duane Hookom
MS Access MVP

" 009SteveJobs" wrote in message
...
How do you create a image link to an external file so that whenever I
change the image, it will reflect on the report? Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Use a subreport that you can place in the Report Header of your reports.

--
Duane Hookom
MS Access MVP

" -DwayneWade" wrote in message
...
Hi,

I want to put a image in my report header and I got 20+
reports have the same header. What is the best way to implement this so
that if I change the image, I don't need to do 20+ times processing?
Thanks.









  #6  
Old November 21st, 2006, 04:31 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default image linked to a report

Find a very, very small image file to insert.

--
Duane Hookom
MS Access MVP

" -01SteveJobs" wrote in message
...
When I add an image control to the report, it automatically asks me for
the image file and then embedded the file. How can I bound it to a field
in a table? THanks.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You store the path to your image in a field "ImageName" so the value
might be something like:
"H:\Data\Images\MySnout.jpg"
Add an image control to your report. Add a text box "txtImageName" to
your report's section.
Then in the On Format event of the section of the report containing your
image control, add code like:

If Len(Dir(Me.txtImageName))0 Then
Me.imgControlName.Picture = Me.txtImageName
Me.imgControlName.Visible = True
Else
Me.imgControlName.Visible = False
End If

--
Duane Hookom
MS Access MVP

" 009SteveJobs" wrote in message
...
How do you create a image link to an external file so that whenever I
change the image, it will reflect on the report? Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Use a subreport that you can place in the Report Header of your
reports.

--
Duane Hookom
MS Access MVP

" -DwayneWade" wrote in message
...
Hi,

I want to put a image in my report header and I got 20+
reports have the same header. What is the best way to implement this
so that if I change the image, I don't need to do 20+ times
processing? Thanks.











  #7  
Old November 21st, 2006, 06:11 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
-003KobeBrian
external usenet poster
 
Posts: 29
Default image linked to a report

I don't understand how this can accomplish what I want. I want to link the
image in a report from a table or a path. But I am getting now is the
picture imported to the report. If I have one same image on 20 report
header and if I change the image, then I need to import 20 times in the
report header. Can you please help? Thanks.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Find a very, very small image file to insert.

--
Duane Hookom
MS Access MVP

" -01SteveJobs" wrote in message
...
When I add an image control to the report, it automatically asks me for
the image file and then embedded the file. How can I bound it to a field
in a table? THanks.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You store the path to your image in a field "ImageName" so the value
might be something like:
"H:\Data\Images\MySnout.jpg"
Add an image control to your report. Add a text box "txtImageName" to
your report's section.
Then in the On Format event of the section of the report containing your
image control, add code like:

If Len(Dir(Me.txtImageName))0 Then
Me.imgControlName.Picture = Me.txtImageName
Me.imgControlName.Visible = True
Else
Me.imgControlName.Visible = False
End If

--
Duane Hookom
MS Access MVP

" 009SteveJobs" wrote in message
...
How do you create a image link to an external file so that whenever I
change the image, it will reflect on the report? Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Use a subreport that you can place in the Report Header of your
reports.

--
Duane Hookom
MS Access MVP

" -DwayneWade" wrote in message
...
Hi,

I want to put a image in my report header and I got 20+
reports have the same header. What is the best way to implement this
so that if I change the image, I don't need to do 20+ times
processing? Thanks.













  #8  
Old November 21st, 2006, 01:37 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default image linked to a report

What is the code that you used? How about some field and control names from
your report? What were your results?


--
Duane Hookom
MS Access MVP

"-003KobeBrian" wrote in message
...
I don't understand how this can accomplish what I want. I want to link
the image in a report from a table or a path. But I am getting now is the
picture imported to the report. If I have one same image on 20 report
header and if I change the image, then I need to import 20 times in the
report header. Can you please help? Thanks.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Find a very, very small image file to insert.

--
Duane Hookom
MS Access MVP

" -01SteveJobs" wrote in message
...
When I add an image control to the report, it automatically asks me for
the image file and then embedded the file. How can I bound it to a
field in a table? THanks.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You store the path to your image in a field "ImageName" so the value
might be something like:
"H:\Data\Images\MySnout.jpg"
Add an image control to your report. Add a text box "txtImageName" to
your report's section.
Then in the On Format event of the section of the report containing
your image control, add code like:

If Len(Dir(Me.txtImageName))0 Then
Me.imgControlName.Picture = Me.txtImageName
Me.imgControlName.Visible = True
Else
Me.imgControlName.Visible = False
End If

--
Duane Hookom
MS Access MVP

" 009SteveJobs" wrote in message
...
How do you create a image link to an external file so that whenever I
change the image, it will reflect on the report? Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Use a subreport that you can place in the Report Header of your
reports.

--
Duane Hookom
MS Access MVP

" -DwayneWade" wrote in message
...
Hi,

I want to put a image in my report header and I got 20+
reports have the same header. What is the best way to implement this
so that if I change the image, I don't need to do 20+ times
processing? Thanks.















  #9  
Old November 22nd, 2006, 12:52 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
-003KobeBrian
external usenet poster
 
Posts: 29
Default image linked to a report

In fact, I didn't use any code. I simply create an image control in the
report and it asked me for the file to be displayed and get imported to the
report. So next time if I change the image, I need to re-import the image
file again.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
What is the code that you used? How about some field and control names
from your report? What were your results?


--
Duane Hookom
MS Access MVP

"-003KobeBrian" wrote in message
...
I don't understand how this can accomplish what I want. I want to link
the image in a report from a table or a path. But I am getting now is the
picture imported to the report. If I have one same image on 20 report
header and if I change the image, then I need to import 20 times in the
report header. Can you please help? Thanks.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Find a very, very small image file to insert.

--
Duane Hookom
MS Access MVP

" -01SteveJobs" wrote in message
...
When I add an image control to the report, it automatically asks me for
the image file and then embedded the file. How can I bound it to a
field in a table? THanks.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You store the path to your image in a field "ImageName" so the value
might be something like:
"H:\Data\Images\MySnout.jpg"
Add an image control to your report. Add a text box "txtImageName" to
your report's section.
Then in the On Format event of the section of the report containing
your image control, add code like:

If Len(Dir(Me.txtImageName))0 Then
Me.imgControlName.Picture = Me.txtImageName
Me.imgControlName.Visible = True
Else
Me.imgControlName.Visible = False
End If

--
Duane Hookom
MS Access MVP

" 009SteveJobs" wrote in message
...
How do you create a image link to an external file so that whenever I
change the image, it will reflect on the report? Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Use a subreport that you can place in the Report Header of your
reports.

--
Duane Hookom
MS Access MVP

" -DwayneWade" wrote in message
...
Hi,

I want to put a image in my report header and I got 20+
reports have the same header. What is the best way to implement
this so that if I change the image, I don't need to do 20+ times
processing? Thanks.

















  #10  
Old November 22nd, 2006, 02:24 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
-003KobeBrian
external usenet poster
 
Posts: 29
Default image linked to a report

Duane,

I got it now. Thanks for your help.


"-003KobeBrian" wrote in message
...
In fact, I didn't use any code. I simply create an image control in the
report and it asked me for the file to be displayed and get imported to
the report. So next time if I change the image, I need to re-import the
image file again.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
What is the code that you used? How about some field and control names
from your report? What were your results?


--
Duane Hookom
MS Access MVP

"-003KobeBrian" wrote in message
...
I don't understand how this can accomplish what I want. I want to link
the image in a report from a table or a path. But I am getting now is the
picture imported to the report. If I have one same image on 20 report
header and if I change the image, then I need to import 20 times in the
report header. Can you please help? Thanks.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Find a very, very small image file to insert.

--
Duane Hookom
MS Access MVP

" -01SteveJobs" wrote in message
...
When I add an image control to the report, it automatically asks me
for the image file and then embedded the file. How can I bound it to
a field in a table? THanks.


"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
You store the path to your image in a field "ImageName" so the value
might be something like:
"H:\Data\Images\MySnout.jpg"
Add an image control to your report. Add a text box "txtImageName" to
your report's section.
Then in the On Format event of the section of the report containing
your image control, add code like:

If Len(Dir(Me.txtImageName))0 Then
Me.imgControlName.Picture = Me.txtImageName
Me.imgControlName.Visible = True
Else
Me.imgControlName.Visible = False
End If

--
Duane Hookom
MS Access MVP

" 009SteveJobs" wrote in message
...
How do you create a image link to an external file so that whenever
I change the image, it will reflect on the report? Thanks.

"Duane Hookom" DuaneAtNoSpanHookomDotNet wrote in message
...
Use a subreport that you can place in the Report Header of your
reports.

--
Duane Hookom
MS Access MVP

" -DwayneWade" wrote in message
...
Hi,

I want to put a image in my report header and I got 20+
reports have the same header. What is the best way to implement
this so that if I change the image, I don't need to do 20+ times
processing? Thanks.



















 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.