For those of you that have followed this blog over the years, you know that I’ve explored various image manipulation tools, things like:
Well, I decided to explore another option, ImageMagick.
A short while ago, about a month ago, I made a posting about one of my Feedback Portal suggestions being deleted without a trace:
I’ve really been trying hard lately! Truly have. I been trying to be that positive guy, try to keep pushing forward with the Feedback Portal, ignoring all the issues, hoping that perhaps some of it would filter through to the Dev Team. Recommending we all continue to contribute that it would show engagement and force Microsoft’s to reciprocate.
BUT, it’s happened again! Another suggestion has vanished!
Executing Command Prompt commands and capturing their output is a task that often arises unexpectedly. Whether you need to run DOS commands or command-line utilities, integrating this functionality into your VBA program can enhance its capabilities.
Surprisingly, Microsoft has not provided a straightforward way to execute these commands directly within VBA, leaving users to devise their own solutions. The need for this functionality spans various scenarios, from simple commands like `dir` and `ipconfig` to more complex command-line utilities, showcasing the true potential of this integration.
A quick search online reveals numerous solutions, many of which involve complex API calls or writing outputs to text files—approaches that can be overwhelming.
In this article, I’ll share a couple of simple methods that have proven effective for me over the years.
Continue reading
In a continuation of my article on Improving the Microsoft Access Interface
I recently released a YouTube video in which I demonstrated how we could take a static menu and switch it to be table/data driven.
In one of my YouTube videos I’ve demonstrated a reliably reproducible bug with the Modern Web Browser Control (MWBC) in which if you try to use a form’s Open event to dynamically set the MWBC’s Control Source, it is completely unreliable and most times it will not render anything.
Typically, the control will render the 1st time it is opened and every subsequent call it will simply give a blank form. The only way to make it work is to perform a C&R, and even that doesn’t always correct the issue.
I was working on a little routine to update a demo file so it would reconfigure the Control Sources of the various Modern Web Browser control (MWBC) to match the database folder (same principle as relinking tables, I’m trying to relink MWBCs).
I thought I’d simply share a quote from a UA forum discussion:
Some people have asked me what I’ve been working on and so I thought I’d share a sneak peak.
Basically, I’ve been working on trying to elevate the Access interface a bit and have been working on a few new menus concepts and thus developing content, demos for my blog and YouTube channel.
If I’ve said it once, I’ve said it a thousand times, the Modern Web Browser Control (MWBC) is simply not a finished product, not nearly tested properly.
Here’s yet another issue with it!
I’ve been trying, in vain, to migrate an HTML page that references web based resources (JS, CSS) to instead use local versions. This is super simple to achieve with traditional browsers, however proving to be a nightmare with the MWBC!
Normally, you simply update the HTML page from
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.1/jquery.min.js" integrity="sha512-v2CJ7UaYy4JwqLDIrZUI/4hqeoQieOmAZNXBeQyjo21dadnwR+8ZaIJVT8EE2iyI61OV8e6M8PP2/4hpQINQ/g==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
to
<script src="../js/jquery.min.js"></script>
Easy, right!
However, things quickly fall apart with the MWBC!!! (AGAIN)
Ever made a mistake?!
It happens.
Say, you input the control source of a Modern Web Browser Control (MWBC) as a local html file, but you make a mistake in the path or file name, so in fact the specified path/filename doesn’t exist.
Ordinarily, in Edge, you get a nice screen that clearly indicates:
File not found
It may have been moved, editied, or deleted.
ERR_FILE_NOT_FOUND
Furthermore, if you open the inspection tools and switch over to the console you’ll see a clear message:
Not allowed to load resource:
file://YourFileName