bradyboyy88
Well-known Member
- Joined
- Feb 25, 2015
- Messages
- 562
I have a userform with a bunch of labels that use a specified image (word doc icon, pdf icon, etc) and these labels in the userform are created dynamically after accessing a database. Sometimes a 1000 of these icons are generated and it takes forever. I know dynamically adding form components is slow as is but I think what is really slowing it down is that I have to keep referencing the file location for the icon's jpeg as I dynamically create them (these icons files are located on a slow network drive to make it worse!). So I have a lot going against me on this but that is why I was hoping I could possibly save the icon image to the excel file itself and embed it and then access the jpeg file image in memory since the excel file is open already. Is this doable or a solution like this exist?
My other idea was to save the file as an attachment in an access database and when we do our ADO query potentially pull that file (not sure if ADO supports this though) and use it in memory . Any other solutions would be worth considering too!
Thanks
Shaun
My other idea was to save the file as an attachment in an access database and when we do our ADO query potentially pull that file (not sure if ADO supports this though) and use it in memory . Any other solutions would be worth considering too!
Thanks
Shaun