I am trying to follow the directions from strongm in the previous closed thread:
thread703-1758167
It doesn't appear to be working for me, probably because there is something I don't understand. I'm a power user, not really a programmer. After setting the format event on the group header section, and creating and saving the function in the module, nothing appears in the report. I suspect it may be related to my not knowing how to switch from the example URL to the field URL. The original that strongm posted was:
Set Image0.Picture = LoadPictureFromURL(" SOurce file - this text could obviously come from a field in a table, for example
I have tried two ways to use the URL from the field in the table. The first won't run at all and gives me a picture1web not found error.
Set Image0.Picture = LoadPictureFromURL([picture1web])
The second will let me see the report, but the picture doesn't appear and if I try to preview or print the report I get an error that says a custom macros has failed to run preventing the report from rendering.
Set Image0.Picture = LoadPictureFromURL("[picture1web]")
The problem might also be that I did the module wrong. I've never added a module to a database before other than to add events to forms. Can anyone help shed some light on this issue?
If not, does anyone have any ideas for me? I just want to print a program guide of workshop leaders names, bios, picture, and workshop descriptions in a book. All of the pictures of the people have been loaded into an Access 2013 database. I can view a form on the screen with the pictures in it, but it won't print. I haven't been able to get the report to show the pictures either (insofar that the web browser object is not supported in reports). I've tried doing a Word Merge, but it just posts the URL and not the picture. If I could figure out how to do it in HTML I would try that, but as I noted, I'm not a real programmer.
Any help would be greatly appreciated.
Peace
CJ Rhoads
thread703-1758167
It doesn't appear to be working for me, probably because there is something I don't understand. I'm a power user, not really a programmer. After setting the format event on the group header section, and creating and saving the function in the module, nothing appears in the report. I suspect it may be related to my not knowing how to switch from the example URL to the field URL. The original that strongm posted was:
Set Image0.Picture = LoadPictureFromURL(" SOurce file - this text could obviously come from a field in a table, for example
I have tried two ways to use the URL from the field in the table. The first won't run at all and gives me a picture1web not found error.
Set Image0.Picture = LoadPictureFromURL([picture1web])
The second will let me see the report, but the picture doesn't appear and if I try to preview or print the report I get an error that says a custom macros has failed to run preventing the report from rendering.
Set Image0.Picture = LoadPictureFromURL("[picture1web]")
The problem might also be that I did the module wrong. I've never added a module to a database before other than to add events to forms. Can anyone help shed some light on this issue?
If not, does anyone have any ideas for me? I just want to print a program guide of workshop leaders names, bios, picture, and workshop descriptions in a book. All of the pictures of the people have been loaded into an Access 2013 database. I can view a form on the screen with the pictures in it, but it won't print. I haven't been able to get the report to show the pictures either (insofar that the web browser object is not supported in reports). I've tried doing a Word Merge, but it just posts the URL and not the picture. If I could figure out how to do it in HTML I would try that, but as I noted, I'm not a real programmer.
Any help would be greatly appreciated.
Peace
CJ Rhoads