Hi, I've got a strange issue where i've been searching for some time without finding a good answer:
I have a database with embedded illustrations which I use to make sparepart lists. The records are all retrieved and nicely ordered inside a report.
In the past worked a lot with queries and this went just fine. Now recently I started to work with VBA to automate and speed up some things.
Now I make reports via SQL with the correct records (just like i had with the integrated queries before in the recordsource), however I noticed, the images are not visible in the reports
I narrowed down and figured out the following:
When I link the recordsource of an (illustrated) report to a query inside the report's properties, the images in my report (which are embedded images per record) are visible.
When however, I use an SQL statement inside the recordsource, which is exactly corresponding to the queries I used before, the images are NOT visible in my report
Does somebody knows what I should do to obtain my images in my reports especially when I want to work with SQL instead of queries (inside my report?)
I really would like to work with SQL as can easily create the correct statements/code in vba...
Thank you!