Results 1 to 8 of 8
  1. #1
    sra2786 is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Location
    Cincinnati, OH
    Posts
    38

    Sales Reports Dialog in Northwind


    Can someone explain to me where the "red" color is set in Properties on the Sales Reports Dialog form? I have attached a picture of the area I am referring to.
    Attached Thumbnails Attached Thumbnails Northwind Sales Reports Dialog.png  

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    That took a minute. There's an embedded image on the form.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    sra2786 is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Location
    Cincinnati, OH
    Posts
    38
    Hmmm .... how do I see/extract the image that was embedded on the form? I am just trying to understand this form.
    Thanks.
    Sandy

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Not sure. I deleted it and the color went away, so that told me where it was.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,407
    The only forms that I have seen to exhibit this header color scheme is in the Microsoft supplied template databases. I have in the past, searched Google for information, and not come up with anything specific, just some suggestions that crudely duplicate the effect. It's a Microsoft mystery.
    Last edited by davegri; 11-15-2018 at 10:32 PM. Reason: sp

  6. #6
    sra2786 is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Location
    Cincinnati, OH
    Posts
    38
    I found the following. I made a copy of the Sales Reports Dialog form because the steps below would not work with an unbound form. I have attached the image. Thank you pbaldy for steering me in the right direction. I am fairly new to Access and did not know that you could use an image in this way.

    This is an embedded background image? According to Access Junkie at http://www.accessjunkie.com/Pages/faq2010_77.aspx the process is:

    1. Take your form that has a background image or AutoFormat that you like
    2. Right-click on the form in the Navigation Pane and select Export >> XML
    3. On the first page of the wizard, select a destination to drop some files (Desktop is fine)
    4. A small dialog will then appear with three check boxes
    5. Select the first option (Data) and third option (Presentation) and then click OK
    6. Click the Close button on the last page of the wizard after the export is complete
    7. Navigate to where you dropped the files and, among other things, you'll find a new folder called Images
    8. Open that folder to claim your prize

    Here is the image
    Attached Thumbnails Attached Thumbnails Copy Of Sales Reports Dialog.png  

  7. #7
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,407
    Good info. I'll make a folder and keep these images for later use...

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem, glad you found that page. Jeff really knows his stuff.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Northwind Sales Database: Form name property
    By Access_Novice in forum Forms
    Replies: 9
    Last Post: 03-25-2016, 07:24 AM
  2. Replies: 1
    Last Post: 07-30-2015, 07:53 AM
  3. Replies: 2
    Last Post: 06-22-2014, 10:26 AM
  4. Save As Dialog Box for Reports
    By eww in forum Programming
    Replies: 1
    Last Post: 12-01-2010, 03:12 PM
  5. Access Reports using Northwind '07 form
    By racerklm in forum Reports
    Replies: 0
    Last Post: 11-09-2009, 09:08 PM

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