A while back, I published a short video of issues I experienced with Microsoft 365 (MS365):
I thought things were resolved, but yesterday more licensing issues surfaced.
I used MS365 the day before, all was good, yet suddenly now it reports (Unlicensed Product)? Say What!
I’d get a pop-up to “Sign in to get started with Access” even though I was already signed in?
So, I’ve been working on putting together a few Slider control options and wanted to provide a Web based solution as Sliders have long existed in HTML and are far more customizable since everything can be configured via CSS!
It took but a quick Google search to find an IE compatible Slider that I wanted to incorporate into a ‘Legacy’ Web Browser control.
I quickly created a stand-alone HTML file, tested it in IE to ensure all was well and it worked perfectly!
I was ready to now bring it into my Access database! Setup the control source, test it out and what do I get?!
Well, 96% of people indicated that they want to learn more about creating Slider controls.
So, in this post, I start covering the subject by introducing the ‘simplest’ (maybe not quite, but what you would think would be the simplest) slider control built entirely using a couple label controls and a command button.
I will post a few more articles in the coming days that will cover other possibilities:
I’m always amazed at the level of pure stupidity that Microsoft exudes at times!
I know, we all have our moments in the sun, myself included, but Microsoft just seems to manage to outdo themselves.
I’m well aware that in an ideal world, Microsoft wants us all running MS365 and thus we would have all migrated all of our existing Web Browser controls to use the ‘new’ Modern Web Browser control, but that isn’t reality, not even close! The fact of the matter, the legacy Web Browser control is still fully supported and thus why fix something that isn’t broken. Beyond which, many people are simply not running MS365 so they don’t even have access to the Modern Web Browser control at all.
All of this to say, that many a database are still using the ‘Legacy’ Web Browser control, thus IE (Internet Explorer)!
In a push to refresh the Access interface I published a couple articles and videos showing how we could pull HTML menus into Access, add security, control what was accessible by whom, drive the content from tables, …
Along the same train of thought, I have been exploring trying to simplify data entry and one of those aspects brought me to Sliders!
Instead of needing to switch to the keyboard, simply dragging a slider can simplify data entry. It also gives a more modern look and feel to an application.
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
Seems like an simple enough question, right!
Now try to create a routine to answer it!
This was in fact a question I recently came across last week in a forum. For some reason, this was one of those questions I just needed to answer out of personal curiosity. I’ve done so much image manipulating … that I was sure I could quickly provide an answer. So I set off.
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.