Search results

That should be called from a form event, such as Form_Open. The setup should include going into Options, then Current database, then choosing a form to open automatically when the access file is opened. The form that you choose will be where you call your LDSerialFSO function from. So, where do...

Ok, so, this works, right? The post in #10 uses this grant type, which is refresh_token: grant_type: refresh_token But in the curl statement, you're using client_credentials as grant_type, so we need to send that instead and also modify the url from https://login.procore.com/oauth/token ❌ to...

Those two records have the same shipping date, what do you do in this case?

Access likes this better SELECT t.Customer, t.ProductFK, t.Shipping, t.Delivery FROM tbl AS t WHERE ( ( ( IIf( IsNull([t].[Shipping]), [t].[Delivery], IIf( IsNull([t].[Delivery]), [t].[Shipping], IIf(...

I'm not sure, this does return your output. I still don't get it though. SELECT t.* FROM tbl AS t INNER JOIN ( SELECT Customer, MIN(IIF(ISNULL(Shipping), Delivery, IIF(ISNULL(Delivery), Shipping, IIF(Shipping < Delivery, Shipping, Delivery)))) AS MinDate FROM tbl WHERE Shipping IS...

Except for customer2 the other customers also have null shipping, what does this depend on again?

Does this work? SELECT t.Customer, t.ProductFK, t.Shipping, t.Delivery FROM tbl AS t WHERE EXISTS ( SELECT 1 FROM tbl AS sub WHERE sub.Customer = t.Customer GROUP BY sub.Customer HAVING MIN(sub.Shipping) = t.Shipping ) ORDER BY t.Customer Edit:Never mind, it does not work

For simplicity's sake, it might be a good idea to forget about the tokens, and just authenticate yourself with every call. Just an idea, always check if the provider has no problem with that. The token architecture is meant for extended usage of the app without requiring constant authentication...

Try this: Dim Request As Object Dim authKey As String Dim stUrl As String Dim response As String Dim requestBody As String stUrl = "https://login.procore.com/oauth/token" Set Request = CreateObject("MSXML2.XMLHTTP") requestBody = "{ ""grant_type"": ""refresh_token"", " & _ """client_id""...

I see that you used the same code key as in the example. vba8957b84a67f6ae55ab79c9767836a0af30b7fb7e4c36b27434993123cce71ec7 doc8957b84a67f6ae55ab79c9767836a0af30b7fb7e4c36b27434993123cce71ec7 In your documentation, it says that if you're going to use authorization_code for grant_type, you need...

Maybe do this: requestBody = "{ ""grant_type"": ""authorization_code"", " & _ """client_id"": ""db0d63cfa7ac3ceed7166081542216ec99e12341300e5e879105e36bd76dbf63"", " & _ """client_secret"": ""0b57e8d87e35370307ba5f98ad456bd155cabacea56d49994afe083e2eb04b54"", " & _ """code""...

https://api.procore.com/oauth/token?client_id=" & gCLIENTID & "client_secret=" & gSECRET This would return something like this: https://api.procore.com/oauth/token?client_id=123client_secret=secret Maybe it should look like this...

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.

This perhaps Sub ListDbObjects() Dim db As DAO.Database Dim obj As Object Set db = DBEngine.OpenDatabase("some_file_path.accdb") For Each obj In db.Containers("modules").Documents Debug.Print obj.Name Next obj ' Examine containers ' Stop Set obj = Nothing...

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...

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

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?

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

You're welcome, I hope it keeps working for a while, that syntax appears to be an old version of how to build their URLs.

This url appeared on a few stack overflow posts regarding your issue: https://moz.com/blog/everything-you-never-wanted-to-know-about-google-maps-parameters