I have a large amout of picture and they don't have the same size so I can't design an unique size form my OLE image.
I have try the property and it work perfectly, my project is now done.
Thank you a lot for all your help !
[thumbsup2]
Yes it's a OLE ActiveX Microsoft Form 2.0 Image.
Can I use this property like this ? : Image1.PictureSizeMode = fmPictureSizeModeStretch
Is it correct ?
Hello !
I come back to you because I was wondering if it is possible to specify a parameter in code that would have for effect to resize the image to the size of the OLE object I insert on my report ?
Indeed it is that !
I just have to counter the problem of null records. For now I have placed "On error go to" except that it fills me my records null by the last image displayed. I think i can fix that with a loop "if".
I'm looking at it next week, I'm in the weekend and I'm coming back to...
I've tried this but a strange error appear : Execution error '2465' Microsoft Access don't found the field "lien1qgis" which is referred to in your expression
However I write clearly that
Set Image1.Picture = LoadPictureFromURL(lien1qgis)
and the source table of the project is well defined...
Ok I will do it :)
Do I need to edit the topic title and to add "Solved" in it ?
nb: I've edit my last message, do you have the answer to this last little problem?
Thank you sooo much !
It work very well, you save me haha :)
EDIT : I test it and It work perfectly with the direct URL past in code but In the "LoadPictureFromURL()" I want to indicate that the path is from a field in a table and I do not succeed ...
I have tried with...
Ok, sorry i'm not realy comfortable with the ActiveX objects :s
Is this object that I need to create ?
I can't test that now I'm not at my workplace (I'm actualy in switzerland so we probably have an hourly shift)
Yes I add the other code, I put it in a new module.
I don't have error on this part of code
I think that is the proper image controle but I still have a doubt about it.
I use this "Image" controle :
Sorry I haven't specify that i tried it before and it provide me an other type of VBA Error:
without the "Set" i have "Execution error '-2147467261 (80004003) _ Automation Error _ Invalid pointer
Hello,
I try to apply the great Strongm code to display a web image in a report but have some issue when I try to "print" the report.
So the link where I found the solution is : https://www.tek-tips.com/viewthread.cfm?qid=1758167
When I try to execute the code I obtain this error message from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.