Microsoft Access: Edge Browser Control is finally here :)

[Mohsin Malik]

also has anyone noticed that the .LocationURL property does not work?

Just tried, the LocationURL property is working fine for both web / local files.

 

[jimmymac1234]

Yes I have done so but still not loading in

 

[jimmymac1234]

I've figured out the problem with the LocationURL property. It works, but what doesnt seem to work is the site navigated to in the Edge Browser control stays continually loading and does not return the fully processed URL. Thus I'm getting the wrong values. Does anyone think this is a bug?

 

[fornes84]

Hello, i'm Marc,
i'm working with pdf previsualization on a Access forms using the new EdgeBrowserControl. I have many documents with spaces in their file name and it seems EdgeBrowserControl doesn't like it, and i can see the pdf using .navigate or using .ControlSource, I try to replace white spaces with "%20" or putting double quotes, but it dosen't work. I appreciate any help. Thanks !!!

 

[isladogs]

Welcome to the forum

Whilst it is always better to remove spaces or replace with underscores, it works for me using "%20" to replace spaces. For example:

Me.EdgeBrowser0.Navigate "https://isladogs.co.uk/uk-postal-address-finder/files/UKPAF%20User%20Guide.pdf"

If these are local PDF files you MUST precede the file path with: https://msaccess/. For example:

Me.EdgeBrowser0.Navigate "https://msaccess/G:\MyFiles\MDS\Website\IAsite\curriculum-enrichment-organise\files\CEO_Program_Features.pdf"

 

[fornes84]

Thanks for your answer but it doesen't work in my situation, I use local PDF files and I'm not allowed to change their names. I show you the example that does'nt work, and the same example deleting the space works.

 

[isladogs]

I've just re-tested.
Online PDFs work fine using %20 in place of spaces. However local PDFs don't - I just get a blank page as well
I will report this to @JoeJimenezMicrosoft as a possible bug.

 

[Supertension]

Hi, I wonder if @JoeJimenezMicrosoft has any feedback on the possible bug issue with spaces in local PDFs. Thanks.

 

[isladogs]

Hi
I got a reply from Joe but forgot to update this thread. The issue will be fixed but I don't know the timescale for this to happen.
For now, you may need to make a copy of the PDF without spaces.

 

[JoeJimenezMicrosoft]

Is there any reason why you can't just set a control source with a space in it? Seems to work for me. I would post a link as example but the forum thinks I'm spamming

I'll still fix this though as the hyperlink dialog automatically encodes urls even when they local, and I have a fix ready, but with the office deployment process may be a bit before it makes it into your build

 

[NauticalGent]

but the forum thinks I'm spamming

Since this was your 10th post (10 is the magic number), you should be able to post a link now!

 

[FrostByte]

I was just playing about with an Edge Browser Control as the background of the form.

Whats bugging me is that would you cant send the control to the back of the other controls (i.e. its always on top of everything else).

 

[isladogs]

That's largely true and the old web browser control had the same behaviour.
Can you explain when /why you want to have a browser control that was partly or wholly covered by another control.

I said largely true. The exception is that a listbox is ALWAYS top of the z-order and so will be on top of a browser control as well.

The listbox behaviour is far more of an issue AFAIAC

 

[Mohsin Malik]

I would like to report a few things. Firstly, over the past week, I have noticed a significant issue on my Office Insider account that the RetrieveJavascriptValue function no longer seems to function as expected. Whenever I attempt to use it timeout with an error message stating 'RetrieveJavascriptValue timed out. Please verify the JavaScript expression supplied is valid.'. I can confirm that this doesn't seem to occur for users on the current channel, and the same code executes flawlessly. Can anyone else confirm if they're encountering the same problem, or is it an isolated issue on my end? I believe this qualifies as a bug that needs to be addressed before rolling out to current channel.

Though the Edge browser control integrates seamlessly in ms-access continuous form and report, it also works great with the ReportHeader, PageHeader, Detail, PageFooter, and ReportFooter within Report. However, the EdgeBrowser Control does not work when you try to use in the FormHeader and FormFooter of an MS-Access form (you can refer to the attached screenshot for reeference). Is there something I might be missing or overlooking? I would appreciate any insights.

 

[JoeJimenezMicrosoft]

I would like to report a few things. Firstly, over the past week, I have noticed a significant issue on my Office Insider account that the RetrieveJavascriptValue function no longer seems to function as expected. Whenever I attempt to use it timeout with an error message stating 'RetrieveJavascriptValue timed out. Please verify the JavaScript expression supplied is valid.'. I can confirm that this doesn't seem to occur for users on the current channel, and the same code executes flawlessly. Can anyone else confirm if they're encountering the same problem, or is it an isolated issue on my end? I believe this qualifies as a bug that needs to be addressed before rolling out to current channel.

Though the Edge browser control integrates seamlessly in ms-access continuous form and report, it also works great with the ReportHeader, PageHeader, Detail, PageFooter, and ReportFooter within Report. However, the EdgeBrowser Control does not work when you try to use in the FormHeader and FormFooter of an MS-Access form (you can refer to the attached screenshot for reeference). Is there something I might be missing or overlooking? I would appreciate any insights.

View attachment 108034

What javascript are you using in retrievejavascriptvalue? And thats strange that the control works in headers/footers for reports but not forms, as under the hood they're essentially the same thing. I can look into that

 

[Mohsin Malik]

What javascript are you using in retrievejavascriptvalue? And thats strange that the control works in headers/footers for reports but not forms, as under the hood they're essentially the same thing. I can look into that

Hi Joe, thank you for your prompt response and checking. I am using a fairly straightforward script, as below. This script is working well for users on the current channel. but return timeout error for Insider build Microsoft® Access® for Microsoft 365 MSO (Version 2306 Build 16.0.16505.20000) 64-bit, no matter what I try, the return result is the timeout message: RetrieveJavascriptValue timed out. Please verify the JavaScript expression supplied is valid.

Javascript Expression:
Me.txtHTML = Me.EdgeBrowser1.RetrieveJavascriptValue("document.getElementsByTagName('table')[0].innerHTML")

Please let me know if you need any additional information, or have any questions.

 

[561414]

Javascript Expression:
Me.txtHTML = Me.EdgeBrowser1.RetrieveJavascriptValue("document.getElementsByTagName('table')[0].innerHTML")

Please let me know if you need any additional information, or have any questions.

Can't the new browser just do this?
Me.txtHTML = Me.EdgeBrowser1.Object.Document.getElementsByTagName("table")(0).innerHTML
???

 

[isladogs]

Can't the new browser just do this?
Me.txtHTML = Me.EdgeBrowser1.Object.Document.getElementsByTagName("table")(0).innerHTML
???

No. The Object property doesn't exist in the Edge browser control

 

[561414]

No. The Object property doesn't exist in the Edge browser control

I don't have that browser control, what variables does the DocumentComplete event expose? is the pDisp variable not available anymore?

Edit:
Regardless of the Object browser not existing anymore, surely there must be access to the Document property, right?

 

[isladogs]

1.

Private Sub EdgeBrowser0_DocumentComplete(URL As Variant)

NOTE: I've updated the above with the correct info. pDisp is not an argument for the new Edge browser

2. EdgeBrowserControl object (Access) | Microsoft Learn