"Google Map" on report with specific URL not working.

[MarMo]

Hi there ,

I searched the net for a solution , but without success.
I want to show ( or print ) on a report a specific URL on Google Maps with the ActiveX control "Microsoft Web Browser".
I managed to use the Google API on a form to show the actual URL found with X and Y coordinates.

Now I'd like to show the same URL on a report to send to the customer as a reference. Is there a way to get this done ?

I already put a ActiveX control (Ms Web Browser) on a report and used the same URLstring in the ActiveX control , but nothing is shown on the screen.

Can someone help me pls.

 

[vbaInet]

Upload a mock up db.

 

[MarMo]

Hi vbaInet ,
Thanks for replying.
In the meanwhile I found a solution for my problem.
It seems that a MS Web Browser control cannot be used within a report. Therefor an image is used instead.
If you want , i can make a mock up db with form and report and upload it on this forum.

 

[vbaInet]

If you have time then yes upload the image control solution as well as the Web Browser problem.

 

[MarMo]

Example almost ready; I'll post it asap.

 

[MarMo]

I've uploaded an example database.

This is an example database to show a possibility on how to print a position map on a report.

The application will show a form where you can see a single or a multiple position map, depending which button you click.
It will also open a report with the same map for printing purposes.
The URL is also shown below the browser and you can change some values in this URL and test it to see the changes.

It is not the most complex programming code , but i wanted to share it anyway.
Maybe it will help someone in the future.
Feel free to comment on it; It would be much appreciated.

 

[vbaInet]

Good! I'll take a look at the web browser later.

 

[MarMo]

Hello there ,
I've tested the application on another computer , and it failed to save the images.
This was due to the permissions on the C drive.
Therefor I made a minor change in the application to set the file path first.

Hopefully it will work correctly now