Results 1 to 5 of 5
  1. #1
    Robert2150 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102

    Inserting a Logo into report headers automatically.


    I have a database that is used by several different organizations.
    I would like to develop some code to allow each organization to insert their logo into the program forms and reports when they first open the program.
    I am thinking of a button that gives the option to add, or change a logo.
    Any Ideas? Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    In your ORG table, make a field of OBJ type.
    paste the logo there, then join the org table to the rpt query.
    the logo can now go in the rpt.

  3. #3
    Robert2150 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102
    Thank you ranman256, I will try it.
    Any more suggestions would be appreciated.

  4. #4
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    1. have a field in your organisation table which contains the path and name of the logo file on your drive/network
    2. in your report, have a hidden textbox populated with the value of this field (could populate in the form current event using dlookup for example)
    3. in your report have an unbound image control with it's controlsource set to the textbox

    benefit is images are kept out of the db

  5. #5
    Robert2150 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102
    Thanks, a lot of good and useful information. It really helps.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 03-04-2015, 10:04 AM
  2. Replies: 2
    Last Post: 04-19-2012, 12:43 PM
  3. Replies: 4
    Last Post: 08-01-2011, 03:36 PM
  4. Report Headers
    By BigCat in forum Reports
    Replies: 1
    Last Post: 06-21-2011, 09:38 AM
  5. Replies: 7
    Last Post: 03-03-2010, 11:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums