Search results

I've replicated the JSON structure with test data.... { "href":"https://api.ebay.com", "total":"30", "next":"https://api.ebay.com/next", "limit":"50", "offset":"0", "orders":{ "0":{"OrderID":"Order1"}, "1":{"OrderID":"Order2"}, "2":{"OrderID":"Order3"} } } Which when dropped...

I appreciate that Colin...but the JSON data is full of confidential information....yes, it's just the OrderID info I need. Ebay have two APIs ...legacy API which uses XML (& contains Legacy OrderIDs - which I've always used to date) & their new REST API which uses JSON (and contains Ebay's...

Thanks...yes, that approach is very XML-esque (which I find painful ...JSON was meant to make things less ugly to pick the bones out of!) I've managed to workaround, but it's a real kludge (which I excel in!), but until I'm more JSON Savvy it'll get me away... Basically I search for a unique...

I'm trying to parse a bit of JSON like this... ...I'm interested in orderIDs (50 of them) ......the path to this field is showing at the top of the jpg. I've clearly got my code set wrong, as after 6 loops it exits (if you look at the top of the jpg there are 6 objects), so I need to set...

A relatively simple solution was found via this link. https://bytes.com/topic/access/answers/923353-preventing-control-losing-focus "I added an invisible control to the form and made it next in the tab order after my input text box. Under the "On Got Focus" of this control i made it return the...

Sure, my main form has a field called ScannedBarcode ....I have set 'AfterUpdate' to run this VBA... Private Sub ScannedBarcode_AfterUpdate() Dim wavfile As String If Not IsNumeric(ScannedBarcode) Then Call PlayWav("C:\AccessData\audio\", "scan_error.wav") MsgBox "You didn't scan a...

Thanks...I'd found that possible contender prior via Google...but it had no effect. For now, I've kludged it by closing/opening the form at the end of my VBA code (which sees the focus back where I want it), but not very elegant!

Thanks. My input box (on the main form), triggers some VBA, which ultimately changes a "quantity" value in a table my subform is simply a query which shows the quantity in the table ....I've no tabs in play (I've not set any) ..it's actually a 'carriage return' arriving from the barcode...

New to forms... I've a form with a data entry box (called ScannedBarcode) ...the idea is a user scana a barcode & stuff then happens. I've a subform which shows information relating to the scanning..... my problem is, when I scan a barcode...the focus is removed from the ScannedBarcode data...

Ok, thanks...I'll need to attack this differently then :-)

I still consider myself fairly entry level at VBA (a complete kludger), as such I'm not particularly well versed in all the tools available in the VBA toolbox (&/or how to deploy), so please let me explain what I need...and perhaps some kind soul will tell me if it exists.... I'm prompting for...

Thank your friend for me ..he's bang on the money :-)

Ok, I've managed to get this bit working...full kudos & credit to Trentium over on stackoverflow who provided this VBA code https://stackoverflow.com/questions/50786635/integrating-amazon-polly-with-vba I've picked the bones out of his code (i.e. the bits I need for hashing) & thankfully have...

That's great, for the purposes of signing, I'm looking at the section called "Deriving a signing key using other languages", at the foot of this page... https://docs.aws.amazon.com/general/latest/gr/signature-v4-examples.html ....it has the test data & results - I seek to sign that test/sample...

It will still work (I still have some old APIs running on their Signing V2)... Signing V4 is enforced only for later APIs

Amazon have changed their signing process...before was Signing Version 2 ... they are now deploying Signing Version 4 - way more convoluted. Like most things if you break the overall large chunks down into smaller components it becomes digestible ...but I'm failing on this one (& it all hinges...

Ok, so I'm trying to knock up an API to connect to Amazon...the API itself isn't the problem, it's the hashing process. To test everyone's hashing process, Amazon provided some test data to work with. The process is to start off with a known key, then use that key to hash some data .....the...

that was a great tip! It transpires some kind soul has posted a working solution in vb.net - The author (stackflow user2728841) said "Here's a complete VB.NET console application that successfully connects to AWS." - connecting to AWS (Amazon's API Server) is exactly what I need :), his full...

They certainly don't make things easy. I hadn't actually realised how similar Python is to VBA (their Python code extract).... method = 'GET' service = 'ec2' host = 'ec2.amazonaws.com' region = 'us-east-1' endpoint = 'https://ec2.amazonaws.com' request_parameters =...

I realise this is pretty niche, and I realise there aren't likely to be anyone on here that has...but hey, worth a shot. Amazon have an API that is a head trip to understand the signing stages (if you wish to suffer from Brain fog, you can read about how they say it should be signed here...