Forum Discussion

EclipseJohn's avatar
EclipseJohn
Copper Contributor
Feb 11, 2020

Quoting Program in Access

Has anyone created or found a way to create great looking quotes in Access using information that we provided in the database? I can create a database of all the necessary stuff that would go on the ...
  • George Hepworth's avatar
    Feb 11, 2020

    EclipseJohn 

    You've made a good start. "... and even create a report view that might look decent..."

     

    This part is not that much more complicated, "...but we would also like to include photos on the quote too. ..." However, it'll require some additional components.

     

    Here's what you need to do.

     

    Create the images for the photos and store them on your network. Typically, that would be a folder dedicated to that purpose.

     

    Add a field to the table which contains records for your components. This new field will contain the path to the image for that component, e.g. "\\OurBigNetwork\Components\images\Image101.jpg"

     

    When you create the report, use that to retrieve the appropriate image into an image control on the report.

     

    Making it "look great" is kinda up to you. 🙂

Resources