Search results

Maybe, my grasp is insufficient, but let's say a table was initially created with a lot of short text fields - but at the time of creation it wasn't known how long the text to be stored there would be.... so 255 bytes was selected as a default Field Size. Am I correct in thinking that if 255 is...

ok, I'm sure this is embarrassingly simple, but... I use the string variable strSQL = all throughout my code / modules & until quite recently that how it looked strSQL, but something has changed over the past week (and it's sure to be something I've done inadvertently)...the same variable in...

Subject says it all really. My coding sees a multitude of modules which are peppered with debug.print lines that are not required anymore, it would take me forever to go through each module manually...is there a slick way of deleting any/all lines starting with debug.print?

Any ideas for a watchdog timer, to say monitor a folder for a file that access has created..... & then notify someone remotely if the file hasn't been generated in the past x minutes? (I'm think email notification, but open to any ideas!)

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