Microsoft Access: Edge Browser Control is finally here :)

[561414]

Thanks, isladogs
Then, OP, would this work perhaps?

Private Sub EdgeBrowser0_DocumentComplete(ByVal pDisp As Object, URL As Variant)
    Me.txtHTML = pDisp.Document.getElementsByTagName("table")(0).innerHTML
End Sub

 

[isladogs]

Sorry but when I checked the code before replying in post #100, the links from the Edge browser object led back to the old web browser control webpage

I've just checked using the Edge browser control and pDisp is no longer an argument for this event. The code now for this event is:

Private Sub EdgeBrowser0_DocumentComplete(URL As Variant)

I've amended post #100

Apologies for the misinformation earlier.

 

[561414]

Oh, but the automation document object must be there in some way, right? maybe

Private Sub EdgeBrowser0_DocumentComplete(URL As Variant)
    Me.txtHTML = Me.EdgeBrowser0.Document.getElementsByTagName("table")(0).innerHTML
End Sub

If they fused the browser with the control, then it "should?" work like that, right?

 

[DalynSoft]

I have been using some code which creates a local file for mapping sites onto Google Maps. It has worked fine when the file is opened up directly in a browser.

When I try to open the file in the new web browser control the web page doesn't appear.

Does anyone have experience with this that I could share my file with to see where I am going wrong?

 

[isladogs]

Is the map to be viewed as an image file in an image control or as a local HTML file in the edge browser control?
If the latter, you must prefix the path with https://msaccess/ followed by the full file path

 

[isladogs]

Oh, but the automation document object must be there in some way, right? maybe

Private Sub EdgeBrowser0_DocumentComplete(URL As Variant)
    Me.txtHTML = Me.EdgeBrowser0.Document.getElementsByTagName("table")(0).innerHTML
End Sub

If they fused the browser with the control, then it "should?" work like that, right?

No. That isn't valid code either. Daniel Pineault has just published a useful reference guide. Its not yet complete but does cover this area

Everything You Never Wanted to Know About the Access Modern Web Browser Control

Everything You Never Wanted to Know About Access' new Modern Web Browser Control. The ins and outs of working with Access' New Modern Web Browser control.

www.devhut.net

 

[DalynSoft]

It is a local file and I have added the prefix. I can open simple "hello World" html files ok but it seems to be something with Google Maps itself. I can share the file itself if this will help

 

[561414]

No. That isn't valid code either. Daniel Pineault has just published a useful reference guide. Its not yet complete but does cover this area

Everything You Never Wanted to Know About the Access Modern Web Browser Control

Everything You Never Wanted to Know About Access' new Modern Web Browser Control. The ins and outs of working with Access' New Modern Web Browser control.

www.devhut.net

Thanks.
By the looks of it, they removed the vba automation that the previous version could use and left javascript handle it all. Seems handy, too bad I can't test it.

 

[isladogs]

@DalynSoft
You're welcome to upload a cut down version of your app but I do wonder why you're saving Google maps locally as HTML files.
Why not just load the googleapis.com/maps URL into a browser control as shown in the annotated map examples below or save it as a local image file?

 

[DalynSoft]

@DalynSoft
You're welcome to upload a cut down version of your app but I do wonder why you're saving Google maps locally as HTML files.
Why not just load the googleapis.com/maps URL into a browser control as shown in the annotated map examples below or save it as a local image file?

My application stores locations of building sites and coordinates for trenches between sites. Users select which sites and trenches they want shown on the map, then a local html file is created that includes all the data, calculates the google map size to include all the selected sites, then plots them onto a map with custom markers and labels. Attached is an example of a created file.

If there is a better way of doing this I am open to suggestions. One idea was to load the html directly into the control, but I don't want to start playing with that until I know that the code can be run.

 

[isladogs]

My application stores locations of building sites and coordinates for trenches between sites. Users select which sites and trenches they want shown on the map, then a local html file is created that includes all the data, calculates the google map size to include all the selected sites, then plots them onto a map with custom markers and labels. Attached is an example of a created file.

If there is a better way of doing this I am open to suggestions. One idea was to load the html directly into the control, but I don't want to start playing with that until I know that the code can be run.

I've had a quick test & can confirm that the map image isn't loading

I'll look at it again later when I have time but unlikely to be today. Hopefully someone else will look at it as well.

In the meantime, I suggest you
a) try the attached local HTML file (add your own API key)
b) look at my 3-part series of articles (and video) on annotating Google maps in Access.

Annotate Google Maps

The first article in a series which demonstrates ways of 'annotating' downloaded maps to personalise these for your clients. Features include the use of marker points, lines, circles & boundary shapes, nearby places and styles. All features are added as new map layers. An example app is provided.

www.isladogs.co.uk

The articles pre-date the new Edge browser control but that shouldn't matter for this purpose
Although my examples are all based on UK postcodes, the principle appears to be the same as what you are doing.

 

[DalynSoft]

In the meantime, I suggest you
a) try the attached local HTML file (add your own API key)

Which attached local HTML file were you referring to? The attachment was your Access database.

 

[isladogs]

Oops! I've just replaced the attachment in post #111 with the zipped HTML file

 

[DalynSoft]

I tried to send this reply but got this message (what was the problem?)

 

[DalynSoft]

Oops! I've just replaced the attachment in post #111 with the zipped HTML file

Tested your HTML in both a browser, and in Access. Both work. This suggests to me the problem is with how google handles the marker paths in the google.maps.Marker variable (or how the new Access Control processes it?)

 

[isladogs]

1. My code in those articles was entirely for building static maps. However, users can still drill down by selecting options on forms. I haven't needed to include street view.
2. New users are not allowed to post links until they reach a certain number of posts. For the benefit of others, the link above was

Microsoft Access Google Map Database | Google Maps with Access

The Google Map Database is a full featured Microsoft Access Database Template that allows for viewing and creating Google Map from your Access Database. All the forms and reports used in the database are built using only native Access controls. Full source code included in purchased product.

www.microsoftaccessexpert.com

I haven't looked at their example database/code.
Suggest you contact the WSI site direct to ask if they have modified their code to work with the new Edge control

 

[DalynSoft]

Thanks for your time - much appreciated. I have sent a message to them and am waiting for a response.

 

[lauro]

I would like to share my experiences with the new Edge Browser control and ask some questions.

I made simple database (1 table with addresses, 1 form, 1 report) and I tried to visualize both internet sites and local files.

That’s what I gathered:

• Internet addresses
  • starting with “https://” are correctly opened in the new Edge Browser control
  • starting with “http://” are opened in my default browser (Firefox 113.0.1 (64 bit))
  • starting with “www” are not opened at all.
• Local files: “.htm”, “.pdf”, “.docx”
  • Without “https://msaccess/”: They are opened quite fast in their application.
  • With "https://msaccess/":
    • Are opened in the new Web Browser control but not so fast (considering that the application is not opened) (or maybe I’m wrong it is opened but it is transparent).
    • “.htm and “.pdf” files are opened only if their name doesn’t have white space (the real name of the file can have %20 instead of white spaces, even if the name in the Access table has white spaces).
    • “.docx” gibberish.
• Mixing local address (“.htm”, “.pdf”) and internet address
  • Mixing different type of local addresses is allowed, but mixing internet addresses and local addresses is not allowed.
  • It all depends from the first record: if it contains an internet address, then all subsequent internet addresses are correctly shown, but not the local ones; if it has a local address then only the local files are displayed.
  • Curiously enough, in reports it’s possible to mix local and internet addresses.
• Reports correctly use the new control

Now my questions:

• If the final user doesn't have Edge installed, does he have to install it to correctly see any content of the new web browser control?
  • I think the answer is YES
• If the final user doesn't have Acrobat Reader installed, does he have to install it to correctly pdf files in the new web browser control?
  • Again the answer should be YES
• If the final user has an older version of Access (for instance 2010) can he still use my database with the new web browser control?
  • I really don't know
• If the final user doesn' have Access at all, but I could give (download) him the Access Runtime, will he be able to use my database with the new web browser control?
  • I really don't know. And which version?

Thanks for the attention,
Lauro

 

[DalynSoft]

(Cross-posted in Access-D so that Shane Groff will see it as well)

Attached is a simplified version of my html file. It just requires putting in a Google API key. The only line that seems to be the problem when run in the Edge Web Control is the call to Google Maps. It work ok when it is opened directly in a web browser. Perhaps a bug in the control's processing of one of the following lines?

<script type="text/javascript" src="http://maps.google.com/maps/api/js?key= ReplaceWithGoogleKey "></script>

map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);

 

[isladogs]

(Cross-posted in Access-D so that Shane Groff will see it as well)

Attached is a simplified version of my html file. It just requires putting in a Google API key. The only line that seems to be the problem when run in the Edge Web Control is the call to Google Maps. It work ok when it is opened directly in a web browser. Perhaps a bug in the control's processing of one of the following lines?

<script type="text/javascript" src="http://maps.google.com/maps/api/js?key= ReplaceWithGoogleKey "></script>

map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);

Alerting @JoeJimenezMicrosoft to your post