Search results

Try this: sURL = "https://maps.google.com/maps?t=k&q=loc:" It's up to you to figure out the zoom. You may also want to consider building the url with the button instead of the current event.

It depends on the endpoint requirements, though. Some of them may require you to do something like this: .SetRequestHeader "Authorization", "Bearer " & MyApiKey .SetRequestHeader "Content-Type", "application/json; charset=UTF-8" .Send myDictionary

Yes, just put it in a dictionary then use the ConvertToJson function of the library. I have a procedure here, I removed some things, but you can get the idea, I hope. This is how you could send the dictionary. Public Sub AddProduct(myProduct As Dictionary) Set oRequest =...

With the library I linked, getting the City from ShipFrom would be like this: Dim ShipFromCity As String Dim json As Object Set json = ParseJson(myJsonString) ShipFromCity= json("RateRequest")("Shipment")("ShipFrom")("Address")("City")

I use this library: https://github.com/VBA-tools/VBA-JSON Drag JsonConverter.bas into your project and use both ConvertToJson and ParseJson functions to use it on the response you get.

When interacting with forms or controls, various events can be triggered based on your actions. These events encompass control events such as Exit, LostFocus, Enter, GotFocus, and Click, among others. Additionally, there are form events like Current, Before/After Update/Insert, and even mouse...

This is just an option: https://www.npmjs.com/package/pdf-merger-js To make it work, "just" do this from MS Access > Create the individual pdf files > Move them to a temporary folder > Run the "merger" app The "merger" app is just a nodejs app that uses the library of code in the link above...

Well, for what it's worth, here's yet another link, but to a portable MySQL server which needs no configuration, you run it and it starts the server and its services automatically. It's a 61MB file, so it's very convenient. https://sourceforge.net/projects/usbwebserver/ I would have posted the...

Wasn't this thread about MySQL?

Just do it. I gave you the tables. What have you done?

Oh my READ-THE-THREAD, super moderator.

OP, it's been a fun day. Here, this is a good basis for your project.

Dude, it was YOU who derailed the thing and it was ME who said he only needed help with the forms Some serious stuff is wrong over here. :ROFLMAO:

@Galaxiom I'm a guy, and the obsessed one is not me, I've been trying to bring the thread back on track for a while already @Pat Hartman There, parameter query, done, sql, rad tools and everything. It can be done as per the initial request. Things appear to have changed now that OP mentioned...

I don't know how many times I have written that my first suggestion was a many to many approach, Pat :( Are you OK? I even posted a database in post #30. I already wrote the VBA code there. In fact, how do you want it? you want some SQL string? Let's cook that thing, it's gonna be easy. Hold on.

Even if I wanted to do it via SQL, there would be a way. You would know it had you read the entire thread and its context. But you went overboard to try to prove your points without considering even what OP needs. Here's the possibility I've been talking about that you and your friend have been...

What is the role of the crew in the two tables?

It is important to approach debates with an open mind and a willingness to consider different perspectives, rather than simply focusing on "winning" at all costs, disqualifying the unknown and discrediting that who does not think like you. In fact, a healthy and productive debate should...

That's an amazing point, we must always use the right tools for the job. If we depend too much on our golden hammer, we just won't grow. Besides, it is also good to know we can do a lot of processing client-side to avoid overloading our database systems. It all depends on the architecture we...

@Pat Hartman My proposal was this first, then I added the possibility of another design that is simpler and, if the extra field(s) were to be added some time in the future, extending the schema is not that big of a deal. Since the title of the thread is "Exploring possibilities", that is one. I...