Search results

Well, first let's see if we can decode the Base64 string. Start out getting the actual Base64 portion of the original data string (I'm guessing everything after the last "/", but we'll have to verify). Probably will look something like this: Function GetBase64DataFromString(StringIn As...

I took a quick look at the SDK and it seems it's only supported for .NET, Java and PHP. If you want, you can write a .NET app and compile a COM library from it that you can consume within VBA, but that would be the only route to utilize it. That said, if you're somewhat familiar with .NET, it...

Base64 is a text-based representation of binary data. You can use VBA to encode/decode it. Below is a link to a function that claims to do so (I haven't tested this one in particular, but there's many out there for you to try): http://www.source-code.biz/snippets/vbasic/12.htm The data is...

As far as I know, QDBC is the only way to do this. It's not particularly difficult: register the driver and run the code, really. Hardest part of that is having the correct license for the driver. Their cloud versions may have some sort of Web API you could use to do this, but I'm not sure...

I love this calendar - have used it in numerous applications. Peter does some great work. Sounds like Colin has you squared away, but didn't want to pass up an opportunity to commend Peter on his work. Cheers,

This might help also: it's bare-bones minimum: https://dymeng.com/parsing-json-with-vba/ hth

Yea, this has been a pet peeve for years. As a quick workaround, you can use the fully qualified enum name instead of just member: Public Enum SomeStuff StuffThis = 0 StuffThat = 1 End Enum Then write: If SomeVar = somestuff. ... when you hit the dot you get the intellisense and can...

>> However this would be an insurmountable task << Can't be much worse than constant corruption and data loss issues, can it? If nothing else, split all the databases first: this is usually a relatively easy process that's not generally risky in terms of breaking a bunch of things. That'll at...

As a side note, there's also the standard windows Close button at the top right of the Access window itself, which (AFIAK) can't be altered with the Ribbon. There is some Windows API code that can be used to disable the button, but I tend to think it's a bit of a hack myself (changing the core...

I strongly agree with ridders... this is one of the first things we learn about corruption prevention: the db gets split, everyone gets their own copy of the fontend to use (this is usually step 2, with step 1 being to turn off AutoCorrupt). Having some sort of update/distribution scheme is...

Also: while underscores are low on my list as a matter of personal preference, they're generally harmless except: do be careful of anything that starts with an underscore, as this has special significance internally. More here if you're interested...

Just an FYI, once the table is linked in Access, you can rename the Access linked table to whatever you want. I usually use a SQL backend, in which case Access by default replaces the schema separator with an underscore, so dbo.Employees becomes dbo_Employees. First thing I do after linking a...

Hi Colin - how is that data getting filled in the control though? Is it bound directly to a table/query? I know we can work with much larger sizes than 64k strings in VBA and JET/ACE: the UI control itself is the only one limited to 64k, but I was just curious how you managed to get more than...

Part of me thinks if we need to parse all this data, why not stuff it into a file and then read the file contents (which can be done in chunks) and parse it that way? Part of me thinks probably not that way because you lose the nice UI factor of having a window to paste in You can somewhat...

Or: have a separate backend specifically for audit data, and link to that. It keeps the bulk of the data elsewhere, but requires near to no maintenance (this is how we handle it in SQL Server: a separate database (or even server, depending) for logging audit trail data). Then if you ever do...

Table builders are always nice. Usually the alternative is to use code tags and build an ASCII table, which is never really fun. Most browsers will detect a filled but non-submitted form and confirm closing and losing changes. Might be easier to leverage some basic markup to get the browsers...

Check and make sure you don't have a filter applied to the view on the table (deceiving you to believe there's only 28 rows while there is in fact much more: I'd sooner believe the database's warning). Also make sure there's no joins in the table. Do you have the exact sql you run? Are there...

Not 100% sure of the scenario, but a few things come to mind: Before the control updates, you need to read the .Text property of it (IIRC), rather than the .Value property. Maybe try that. Also, many people reference the control itself, which usually resolves to the .Value property. Try...

Great post DocMan. It hits on a few of the many reasons we've decided not to go this route in the past. Security aside, the maintenance window thing is a big one as well. Then we often have customer "weight" comparisons: does one large customers hog resources for 90% of the system while five...

Databases don't really get "full" - instead they get to a point where you need to upgrade the database (e.g., if you're reaching the 2GB limit of Access, maybe consider moving the SQL Express, which gives you 10GB for free). 2GB is a lot of data: what information are you storing? Binary data...