Recent content by Jason Lee Hayes

Sweet... Thanks for sharing....

The choice to use MS Access ultimately depends on your initial purpose. If your goal is financial gain, MS Access may not be the ideal solution. However, if your focus is on fulfilling specific database requirements, platforms like Caspio might be worth considering. Personally, if I were...

All sorted. Issue was registry corruption causing intermittent use of Outlook (New) which has no COM function. Re-done OS & APP layers and force use of Outlook (Classic) & prevented Outlook (New) from ever being installed or used irrespective of OS Updates and channel... Thanks for all your help (y)

Me neither, all 32bit so far. I am considering 64bit for a new project though as i feel it maybe the right time as its been around for a while now..

Yes, me too.. I would like to think i could achieve what i require without making use of 3 party addons but i dont have the knowledge of Access & VBA. Without these 3rd party tools i honestly think this would limit me providing the simplicity to the end client.

I understand the 32bit approach and its my first choice for many reasons. I am concious however that my lack of knowledge forces me down this path hrystorically however im considering a new project soon and IF i choose Access for the project would like to think i can move away from 32bit and...

Yes, i suggest most of us have been bitten more than once and the end client sometimes does not understand MS are at the forefront of the problem. We learn then to sandbox everything; turn all updates off for OS, Driver and Application Layer and keep an eye on the shit that follows before we...

lol, won't be the first time haha

Certainly, there is no definitive "best version." I am simply curious about which office version is predominantly used and whether it its 32-bit or 64-bit.

Yes, meant to say Outlook (New) appears to be the issue... Previous comment may suggest Outlook (Classic) was the problem... Your right... Bloody Microsoft pushing out shite unfinished stuff yet again lol

Hi Gasman.. Thanks for testing; much appreciated... After many hours of testing and getting frustrated with MS access as usual, it appears that most of the issues were related to the fact that the code was using Outlook (Classic) sometimes instead of Outlook (New) at random and irregular...

Hi, Thanks for the replies and support. I am going to put this idea on hold now as I have exhausted the VBA. I achieved what I using email piping for now. The issue with this code is it fails to accurately identify new mail within inbox folder. To keep it simple, I forcefully used the default...

Hi, Struggling; I'm trying to open Outlook from VBA that searches all email received from all accounts in the past 2 minutes and report true IF an email subject line contains specific words. The following code runs; no issue but fails to identify. Any help would be appreciated. Sub...

Sub OpenAndSetControlSource() ' Declare variables Dim db As DAO.Database Dim rs As DAO.Recordset Dim formName As String ' Set the form name formName = "YourFormName" ' Replace with your actual form name ' Open the form DoCmd.OpenForm formName, acNormal '...