A quick word of caution and tip of the day regarding doing development using the Microsoft Access Modern Web Browser control.
With the extensive development I have done with the Modern Web Browser control, I have noticed some inconsistencies in it reflecting updates I have made to code during development.
For those of you that have tried to dynamically generate content for the Modern Web Browser control a warning that sadly this new control is simply unreliable and far inferior to its predecessor!
I recently decided to create an Outlook Template file to try and save some time when sending some standardized e-mails.
Once created, I was surprised the number of clicks required to simply start a new e-mail based on a template file
and this was going to be something I’d need to do frequently. Stop the insanity!
What could I do to save myself all these clicks, selections …??
VBA, of course!
Have you ever wondered how some people get employed? How some software gets developed? How issues get through Testing? Who thought an idea was a good one?!
Well, that was me a moment ago seriously questioning the competence at Microsoft, again!
I was in the Printers & scanners dialog and accidentally pressed the Remove device button. Oooops!
Luckily for me, Windows offers a confirmation dialog. Right!
After my previous post
I decided to continue development and hence today I present to you an approach to searching for appointments. The beauty here is once you implement this type of framework you can then easily:
Furthermore, such a Framework can be applied to just about any Outlook Items:
I thought I’d share some code to search/filter an Outlook folder to find specific e-mail items and then save them as individual MSG files on the hard drive (location of your choosing)
The code presented below is building upon my article
in which I explain how you can build search criteria to find specific items within Outlook.
Here’s a useful function I’ve pulled from my archives that I thought might help a few of you out there.
How to automate, clearing the VBA/VBE Immediate windows of its content.
The code below is one of the only times I will use SendKeys. I also have another version which only uses APIs and avoids SendKeys, but obviously is more involved from a coding perspective. Perhaps a post for another day.
Yesterday, I presented an approach to manage to display an image in the old Web Browser control so it was resized to fit a given box while retaining its aspect ratio, you can read the details by reviewing
I figured I quickly demonstrate the required code to do the same in the new Modern Web Browser control since the is a better simpler approach that we can employ which reduces the HTML/CSS required.
So I came across a recent question on UtterAccess
and figured I’d share something I had done many years ago.
So, I went digging, and well, couldn’t locate the project. 🙁
So, I figured I had done it once, I could simply do it again and I did.
The entire thing here is resizing the image isn’t complicated, but preserving the aspect ration is a little tricky. Normally, we would simply apply the desired height/width attributes to the image itself, but that will distort the image. I also didn’t want to get into downloading the images locally to be able to read their size properties (height/width) to then be able to calculate the proportional dimensions to respect the desired size, just not efficient and a waste of I/O operations… So we need another approach.
I should also quickly mention that the following is a solution for the old Web Browser control and there is simpler code to do the same thing in the Modern Web Browser control (maybe another article in the coming days/weeks).
Have you ever accidentally, or one of your users, deleted a table?
Need to bring it back? Well, it can normally be recovered.
Don’t close the database, don’t compact the database, don’t do anything else.
The first thing to try is a simply undo (Ctrl+z). In many instances this will work to recover the table(s).
If not, then simply copy the following function into your database and run it.
I take no credit for the original code, instead, all I’ve done is modify it to be able to recover multiple tables instead of just the last one.
Enough talk, here’s the code: