Add a picture from a folder into a report
Hi all,
I've got a client who would like to load a picture for a stock item from a Windows folder. I have found VBA code to generate a comment, but cant seem to find how to just populate it with a picture?
Any help would be appreciated!
I've got a client who would like to load a picture for a stock item from a Windows folder. I have found VBA code to generate a comment, but cant seem to find how to just populate it with a picture?
Any help would be appreciated!
Tags: AddPicture, VBA
Views: 1
Replies to This Discussion
-
Permalink Reply by Raymond "Ray" Krebbs on -
For a table I think you can just create a field with type, OLE Object. Then you can just drag the picture into that field in datasheet view. For a form, in design view, just click on the image icon on the toolbar. That's the simple way. Hope this helps
-
Permalink Reply by Herman van Noordwyk on -
Hi Raymond,
The client wants an e-mailable file to e-mail quotes to clients. Lets assume they've got 50 000 products, it would result in a very large file, especially if they've only got to quote on 5.
I need Excel to only pull the pictures in the report, from a folder of JPEG files.
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
