Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / January 2007

Tip: Looking for answers? Try searching our database.

a "Selected"  Graphic in a Report Header

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tomrector@svsatscott.com - 13 Jan 2007 14:28 GMT
Thanks again for all the help this group has provided !  Simply
amazing.

  I have a database that I use to create a "class listing" each month,
works pretty good,  I am trying to enhance it.   On the form I use to
select the Classes that will show on the report I want to add a drop
down selection that will allow me to select a graphic to be displayed
in the report header.

I will use a table query in the dropdown to select a txtfilename for
the graphic file to be linked. I will build the table with flie names
as text.

  My problem is I don't know where to start mostly,

  I presume the easiest way is a link to a graphic file(txtfilename)
that can be displayed in the header.
   What type of control do I need in the header and specifically how
do I tell the control to link.
   The resulting report will be a print to PDF file from the current
machine.

Or is there a better way ?

Thanks Again !
Tom
tomrector@svsatscott.com
Rick Brandt - 13 Jan 2007 14:49 GMT
> Thanks again for all the help this group has provided !  Simply
> amazing.
[quoted text clipped - 19 lines]
>
> Or is there a better way ?

Use an image control and set the Picture property of the control in the Open
Event of your report to the desired image file.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

tomrector@svsatscott.com - 17 Jan 2007 15:56 GMT
Rick,
First,  thanks for the response,
  I think you misunderstand me, or I didn't clearly relate.
 I want the user to be able to change the graphic (bmp) being
displayed in the report header by selecting the file name of that
graphic from a drop down box (on a form)  (based on a table of the file
names of the graphics loaded on the drive).

Tom

> > Thanks again for all the help this group has provided !  Simply
> > amazing.
[quoted text clipped - 27 lines]
> Email (as appropriate) to...
> RBrandt   at   Hunter   dot   com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.