Search results

Does anyone have the 'chops' to be able to arrange the following short snippet of code into VBA... POST /auth/connect/token HTTP/1.1 Host: sandbox.parcel2go.com User-Agent: insomnia/5.14.6 Content-Type: application/x-www-form-urlencoded Accept: */* grant_type=client_credentials...

I'm trying to parse using the popular VBA JSON parser, but because a key doesn't exist, my code breaks with a Run-Time error 13 Type Mismatch. Here's my line of code... EbayTaxType = json("lineItems")(1)("ebayCollectAndRemitTaxes")(1)("taxType") ...I've done a google search, but I'm going...

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

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

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

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

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

Really struggling here wrt constructing the initial API call (for Shopify) ...there's not a lot of related info via a google search. Has anyone got any code to get me off the ground? All I seek is the most basic of code to construct a proper formatted get request using Shopify API key...

So I have a problem where an e table is throwing up some whacky numbers In my access table I have configured as "doubles" The ShippingTotal field is calculated by a basic formula .... ShippingNet + ShippingTax - ShippingDiscountNet - ShippingTaxDiscount in the access table it all looks...

I have a query sourced from several Access tables that gets exported like this... the problem is Xero (an accounts app), won't accept the shipping cost on the same row, but needs it to be broken out onto its own dedicated row, like this... my question is what would be the most efficient...

For some bizarre reason Ebay has just started randomly adding to the the following text to StreetAddress2 field (the following are just 3 random examples).. Ebayj4jvksc Ebayv4jmfz6 Ebayp4jjqv3 ...it's always Ebay...followed by 7 random characters (therefore 11 characters in total)...when...

Tearing my hair out here (I've not worked with forms much, must be missing the point here!) I'll keep it simple.....let's say I have a table with a field in it called "Barcode" So I have a form setup with the field Barcode showing (ready to accept input) What I want to do is take the data...

I have a working solution for UK/US addresess, which typically follow this format 123 Station Road but Germans Italians & Spanish etc reverse things, for example... Via Trieste 22 ...any ideas how I can break out the above to 22 (Property number) Via Trieste (Street Name) So, I need to...

So I've set up an MS Access ODBC connection a remote mySQL database (shopping cart database) - I've deleted some linked table records on the remote mySQL database using MS Access ...they have deleted, but now whenever I open the - just shows #Deleted ...I'd expected them to actually disappear...

if I have two criteria for a dlookup...one being text & the other a number ...bot stored in variable what would the command be? So for example, two variables.... search_name = "john" search_age = 49 I wish to use those variables above to search a table called members for a surname using...

I seek a way of selecting a table field, then having a preset autokey (shortcut key) configured, that when pressed, runs a bit of VBA, that inserts a number (1 more than the last) into the selected field. I know how to do autokeys. I know how to store a number, recall it, increment it, then...

Any ideas re an elegant dependable way that I can extract the bit in red out of a text string... 7501243706 For Transaction: 7501021926DSPT21174531807 ...in other words when the characters DSPT are found, get everything that follows....so from that long text string, I'd like to end up with...

Just has a situation today where my wife entered a product code into a field...but she had added a trailing space (which caused a few problems). How can I construct a field validation rule to disallow spaces? (either leading or trailing? Would it be something like this... Is Null OR Not Like...

I currently use a Access DB as a single user to help me run my small online home business. My wife helps me in the business now & then & carries out certain tasks using access ...this leads to contention for the seat at the PC where Access is running! I've read up a little & think the best way...

What function/formula should I use to limit a number to TWO decimal places (I don't want to round), example 3.713 ...I only want 3.71 25.8576 ...I only want 25.85 thanks in advance