Search results

The name "Actris" conflicts with several existing company, brand, and project names. I recommend to change that name to avoid confusion and maybe even legal troubles.

Exactly. That's why you declared it as IUnknown, isn't it? It might even make more sense to not even do that but only store the reference to it in a LongPtr. - However, I guess then it's the developers responsibility to explicitly call AddRef/Release when appropriate.

I tried once quite a while ago. - I didn't have the patience to achieve success. On first glance, the code on MrExcel looks complex indeed, but I fear this is what is required to make it work with pure VBA/API.

I doubt this will help. The problem is not the hostname of the server, but the IP addresses of the clients used for restricting access to the MySql server to known hosts only, - Is this correct, @nector ? Even when using dynamic DNS services like DYN (formerly DynDNS), a reverse DNS lookup of...

When would that happen? If you define the data as an array of bytes, I don't see why it would change to a different data type without you doing it in your code.

The Backstage XML works unchanged even in the newest versions of Microsoft Access. However, someday in recent years, I believe in 2021, Microsoft introduced an entirely new screen to the Office applications; the "Home" screen. (The "Home" screen is different from the "Home" tab in the...

JFTR: VBA does not have garbage collection. Memory for object variables is released based on COM reference counting.

Ok, I misunderstood this, but ... ...actually... I don't think this is a good idea. And I think, you will agree... On my computer a .jpeg file will open by default in an application, which identifies itself as Photos.exe. Now look at the registry key you were referring to:

@KitaYama and @cheekybuddha, I get the impression that you completely skipped an important step: How do you know that Microsoft.Photo.exe is actually the application the user has configured for viewing these types of files? I really wonder why nobody pursued this approach, which, in theory...

@KitaYama , did you notice that the backslashes in the path were replaced with the Yen currency symbol in your screenshot?

...which might also include picture viewer applications the user started independently of the Access app. dllhost.exe may run an wide variety of DLLs for a wide variety of purposes. Not necessarily. See #6.

Good approach in theory. In practice there might be a problem.... The default picture viewer, as defined in the Windows Registry, will often be: %SystemRoot%\System32\rundll32.exe "%ProgramFiles%\Windows Photo Viewer\PhotoViewer.dll", ImageView_Fullscreen %1 However, the actual running process...

Trusted Locations are per Office Application. So, it will not work to use Excel (or Word) to define a Trusted Location for an Access file.

I had the very same problem in the past and wrote on it here: Compiling an Access project with VB-Script

An Access add-in requires more configuration/installation and is prone to problems when run unattended. I would rather use a script to directly set all required properties. You could still use an add-in to create the XML configuration file, but the build process itself should run without an...

@Josef P. , thank you for your work and the posts here. I understand your scripts are customized for GitHub Workflows. Did you also evaluate how this approach can be transferred to Azure Pipelines?

If you combine the three queries into one using a UNION query, as @Gasman suggested, you will get the desired result. With ADO Recordsets it would also be possible to copy the records from multiple recordsets into one new recordset. However, this would be rather slow row-by-row operation. The...

If the suggested solution for timestamping actually ever worked (I strongly doubt it), it should still work regardless of where the certificate is stored. The new (2023) requirement for secure storage is not technically enforced. It is just an agreement by the certificate issuers industry...

It is possible for an organization to create email accounts with a 3rd-party provider and then the user (you) creating a personal Microsoft Account with that email address. But this is rather unusual. Normally, the organization's IT admins would register the domain as a Microsoft 365 Tenant...

Your above statements contradict each other. If the "problem" only exists with your account in yourOrganizationDomain, it is clearly not your private account, but an account set up by your organization for you.