Every once in a while when manipulating string odd things happen that can be hard to figure out.
- Why is the a line break
- Why is there a space
- …
Tag Archives: MS Access
Modern Web Browser Control Click Event Not Exposed In VBA
Found another bug with the Modern Web Browser Control (MWBC).
If we look at the Property Sheet for a MWBC, we get:
Modern Web Browser Control Click Event Bug
I’ve been ‘lucky‘ enough to encounter, yet another, Modern Web Browser Control (MWBC) bug! 😩🫤
I used the MWBC’s Click event to be able to identify what the user clicked upon in the web page so I can react to the select via VBA.
If I use a MWBC control source linked to a local file:
="https://msaccess/C:\Demos\Interfaces\Menu01.html"
this all works fine. The Click Event work perfectly.
Continue reading
Deleting Calendar Events With The Microsoft Graph API
While I was exploring the Microsoft Graph REST API and working with Calendar Events:
Use The Microsoft Graph REST API To Create An Event In The User's Calendar
So after my recent YouTube video on sending an e-mail via an Outlook.com account using the Microsoft Graph REST API: I thought I’d provide a function which can be used to create an event in the user’s calendar. (it is still a work in progress though)
Searching Calendar Events With The Microsoft Graph API
Working off of my existing demo and previous posts: I wanted to share 2 routines I’ve created for searching/listing events in a calendar.
the next logical step was to delete an event and nothing could be easier!
Searching Calendar Events With The Microsoft Graph API
Working off of my existing demo and previous posts:
How-to Send E-mails Via Outlook Using The Microsoft Graph API
Well, unless you’ve been living under a rock, by now, you are aware of some fundamental changes coming to Outlook in the not too distant future, mainly the fact that it will cease to support any form of VBA! Now, many have tried to make Microsoft reverse course, understand the millions of solutions (Access, Word, Excel, …) that will instantaneously break with such a switch, but there has been no change in course. Actually, per the usual, there has been little to no response whatsoever. This brings us to today’s post!
Use The Microsoft Graph REST API To Create An Event In The User's Calendar
So after my recent YouTube video on sending an e-mail via an Outlook.com account using the Microsoft Graph REST API: I thought I’d provide a function which can be used to create an event in the user’s calendar. (it is still a work in progress though)
I wanted to share 2 routines I’ve created for searching/listing events in a calendar.
Interesting New Access Project On The Horizon To Decompile Accde Files
I thought I’d share that there is a new Access tool/project on the horizon, one that would allow reverse engineering accde file.
If you want to learn more, then check out:
How Popular Is Microsoft Access, Really?!
I decided to have a little fun after seeing Mike Wolfe’s recent article:
How Many People Use Microsoft Access?
Anecdotal estimates vary wildly. After scouring the internet, I’ve only found one (semi-) official number. And it’s probably a lot higher than you think.
and see what I could dig up.
You see, I don’t think Microsoft’s own numbers are accurate. With later versions of Windows and Office, yes, they have telemetry, but there are multiple older versions still in use that they have no visibility on whatsoever!
This is why there is no true way to get an exact number. It’s educated guess work at best and pure speculation at worst. That said, we can get a better idea relative to other databases via surveys and various sites that rank such data.
Below is some data I found by searching online, so let’s see what picture the data is showing.
How-to Create Linked Tables Via VBA
Although we have GUI tools to create Linked tables, at times, it is simply more convenient to do so via VBA and automate the process.
So I thought I’d quickly share my routine for doing so. I’ve made it primarily for 2 usage scenarios, creating linked tables to:
- Microsoft Access databases
- SQL Server/Azure SQL databases
Another Day, Another Deleted Feedback Portal Suggestion!
A little over a year ago I wrote an article regarding retrieving a database object’s created and modified date/times:
Microsoft Access - Get Object Created Or Modified Date/Time
Getting the Creation Date/Time So have you ever tried to retrieve the Created Date/Time. Pretty easy right as there are a couple ways to attack this! You can simply query the MSysObjects table: Or perhaps use DAO Containers and Documents: Getting the Last Modified Date/Time But what about the Modified Date/Time? So you would think that we could simply modify the above query of the MSysObjects table to: Or the DAO Containers and Documents to: But those are not reliable and don’t always work properly! (especially for Forms and Reports). Instead, they seem to return the Created Date/Time again.…
In it, I detailed that the Last Modified properties was in fact unreliable and hence there was a bug.
So, at the end of the article, I included a link to a Feedback Portal suggestion I created about the issue in the hopes Microsoft would decided to fix this issue for us all.
Use The Microsoft Graph REST API To Create An Event In The User’s Calendar
So after my recent YouTube video on sending an e-mail via an Outlook.com account using the Microsoft Graph REST API:
I thought I’d provide a function which can be used to create an event in the user’s calendar. (it is still a work in progress though)