Forum Discussion
Quoting Program in Access
- Feb 11, 2020
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. 🙂
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. 🙂