Microsoft Access: Edge Browser Control is finally here :)

[bonAW]

What is this about?
View attachment 111639

When the link is clearly visible in the previous post?

I had to remove it in order to reply, which I'm guessing is because there's a limit on new users posting links. Just an attempt at transparency.

 

[Gasman]

Ah, OK.
Yes you need a certain number of post to post a link, though I did not realise it involved quoted posts.

 

[isladogs]

You don’t need to include a quote when it’s obvious what/who you are replying to (as was the case here)

 

[bonAW]

Also fair. Haven't been on a proper forum like this in years so my etiquette is a bit rusty.

 

[Travelix]

Does anyone know if the Google Maps issues (see Posts 110, 119, 183) have been fixed?

 

[GPGeorge]

Does anyone know if the Google Maps issues (see Posts 110, 119, 183) have been fixed?

What happens when you try it in your application?

 

[Travelix]

What happens when you try it in your application?

I'm currently still using the old web browser control because I'm still working with Access 2021. In the registry, the corresponding access parameter for the browser is set to 99.999 and with version 3.52 of the Google Maps Javascript API I can easily display an interactive Google map in a form in the web browser control.

But this is only a temporary solution because version 3.52 will no longer be available shortly and with versions 3.53 and higher, the solution with the old web browser control unfortunately no longer works.

Because I purchased Office 2021 last year, I don't want to subscribe to Office 365 instead until I know whether my application will work with the new Edge Browser Control.

 

[isladogs]

I believe all those issues in posts #110, #119 & #183 have now been fixed.
However other issues have since arisen due to changes in external code.
As a result, I suggest you wait until those are fixed. Hopefully in the next month or so.

Alternatively, download a trial copy of M365 and test for yourself. If you cancel within the first 30 days, you won't pay anything.
You will need to rewrite parts of your code to work with the Edge browser control

 

[Travelix]

Thanks for the information, so I'll just wait

 

[isladogs]

I've just discovered that at least one of the recent regressions for the Edge browser control has been fixed . . . at least that is the case in the Beta Channel version 2403 build 17419.20000 that I'm using..
The fix is Access no longer crashes when code is run on a hidden web browser control
So for example my example app below is now working again (in that build) without me making any changes to it.

Get Current Geolocation

Use this utility to obtain your current geolocation in Access and display a map.

www.isladogs.co.uk

I would be grateful if someone on the current channel could test & report back

Also please let me know whether any of the other recently reported bugs has been fixed

 

[mehdi.ar]

HI
Is it possible to create a dynamic URL link for edge browser?
I want o to change the view every time i update the combo box


Private Sub Combo4_AfterUpdate()
Dim pdfPath As String
pdfPath = Me.Combo4.Value
Me.EdgeBrowser0.Navigate pdfPath
Me.EdgeBrowser0.requery
Me.EdgeBrowser0.refresh

End Sub

 

[isladogs]

Yes. It can be done easily.
The following code is for a listbox but it should work with a combo
For convenience, I populate a textbox with the selected URL and navigate to that

Private Sub lstURL_AfterUpdate()
    Me.txtURL = Me.lstURL
    DoEvents  
    Me.EdgeBrowser2.Navigate Me.txtURL  
End Sub

As the comments on the form make clear, there was a bug preventing this working but it was fixed over a year ago.

 

[Eugene-LS]

Me.EdgeBrowser2.Navigate Me.txtURL

I think it's safer this way:

Private Sub lstURL_AfterUpdate()
Dim sVal$
    sVal = Me.lstURL
    Me.txtWebAddress2 = sVal
   
    sVal = "document.location.href = '" & sVal & "';"
    Call Me.EdgeBrowser2.ExecuteJavascript(sVal)
 
End Sub

 

[Gasman]

Why the intermediary sVal before you populate it with the text?

 

[Eugene-LS]

Why the intermediary sVal before you populate it with the text?

I just have that kind of style ...

 

[isladogs]

@Eugene-LS
In what way is your code safer in your opinion?

 

[MsAccessNL]

Webbrowser in Form without Control !!!! Years to late....

I worked on this many years ago, my gut told me it should be possible, i was so close. Years later i solved the puzzle (bit to late..)Edit thread We could have worked with the modern webbrowsers inside access for many years already, without using any control. I can also open Excel, Word...

www.access-programmers.co.uk

 

[CJ_London]

Think the posts you are referring to were deleted by the poster, either because they were in the wrong thread or they decided to post something different. Not weird

 

[isladogs]

Jon posted in one of those threads that he closed both threads and removed someone's name because of legal ofcom reasons, but I didn't see anything inappropriate in either threads other than an anonymous contributor.

The person who sent me the database from the deleted article at "You Know Who's" website said they would prefer to remain anonymous when I asked if I could thank them publicly (in line with my standard practice). That was his/her personal preference which I respected.
Absolutely nothing inappropriate in that.

 

[isladogs]

It had absolutely nothing to do with the thread being closed.
You raised it as being inappropriate - I responded to that comment.

If you want to post a thread to the Code Repository or Sample Databases, then go ahead.
Not sure I see the relevance to the now closed threads