SOLVED

Quoting Program in Access

%3CLINGO-SUB%20id%3D%22lingo-sub-1167440%22%20slang%3D%22en-US%22%3EQuoting%20Program%20in%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1167440%22%20slang%3D%22en-US%22%3E%3CP%3EHas%20anyone%20created%20or%20found%20a%20way%20to%20create%20great%20looking%20quotes%20in%20Access%20using%20information%20that%20we%20provided%20in%20the%20database%3F%20I%20can%20create%20a%20database%20of%20all%20the%20necessary%20stuff%20that%20would%20go%20on%20the%20quote%20and%20even%20create%20a%20report%20view%20that%20might%20look%20decent%20but%20we%20would%20also%20like%20to%20include%20photos%20on%20the%20quote%20too.%20Also%2C%20quotes%20could%20be%20multiple%20pages%20with%20multiple%20widgets%20quoted%20to%20the%20customer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1167440%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1167708%22%20slang%3D%22en-US%22%3ERe%3A%20Quoting%20Program%20in%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1167708%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F553725%22%20target%3D%22_blank%22%3E%40EclipseJohn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou've%20made%20a%20good%20start.%20%22...%3CSPAN%3E%26nbsp%3Band%20even%20create%20a%20report%20view%20that%20might%20look%20decent...%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThis%20part%20is%20not%20that%20much%20more%20complicated%2C%20%22...but%20we%20would%20also%20like%20to%20include%20photos%20on%20the%20quote%20too.%20...%22%20However%2C%20it'll%20require%20some%20additional%20components.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHere's%20what%20you%20need%20to%20do.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECreate%20the%20images%20for%20the%20photos%20and%20store%20them%20on%20your%20network.%20Typically%2C%20that%20would%20be%20a%20folder%20dedicated%20to%20that%20purpose.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAdd%20a%20field%20to%20the%20table%20which%20contains%20records%20for%20your%20components.%20This%20new%20field%20will%20contain%20the%20path%20to%20the%20image%20for%20that%20component%2C%20e.g.%20%22%5C%5COurBigNetwork%5CComponents%5Cimages%5CImage101.jpg%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWhen%20you%20create%20the%20report%2C%20use%20that%20to%20retrieve%20the%20appropriate%20image%20into%20an%20image%20control%20on%20the%20report.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMaking%20it%20%22look%20great%22%20is%20kinda%20up%20to%20you.%20%3A)%3C%2Fimg%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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 quote and even create a report view that might look decent but we would also like to include photos on the quote too. Also, quotes could be multiple pages with multiple widgets quoted to the customer.

 

Thanks!

1 Reply
Highlighted
Best Response confirmed by EclipseJohn (Occasional Visitor)
Solution

@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. :)