Search results

Deleting the objects in the database file directly is less time-consuming if it is only a matter of creating the versions. The variant with the exported files would have the advantage that you can use version control system with different branches fro each app version, then you could update the...

You can use a Win API function to check whether the mouse button is being held down at the current time.

You could create an application in which you configure the different versions and then create the different versions similar to the msaccess-vcs. In principle, you could even use the msaccess vcs to create it. You just have to make sure that the appropriate files are available in the folder of...

If these "modules" are standalone, you could consider calling them as an "add-on/add-in" from a start application. But I see more disadvantages in splitting it up than just maintaining one big application and “unlocking” only the required modules in it. The only advantage is that you only have...

I use this code in the attached example: Private Declare PtrSafe Function SetLayeredWindowAttributes Lib "user32" (ByVal Hwnd As LongPtr, ByVal crKey As Long, ByVal bAlpha As Byte, ByVal dwFlags As Long) As Long ... Private Sub SetWindowTransparency(ByVal FormHwnd As LongPtr, ByVal...

Public Sub mac() ' End Sub Does the code above trigger the same error?

The behavior that Recalc acts like Requery seems to be related to DataEntry = True. Quick test: Please rename the DemoClientID textbox to tbDemoClientID and then try adding new data. Regardless of behavior: What is the purpose of Recalc? Textbox.Requery is also available.

The fact that =Sum(DataField) only shows the sum of the stored values is the expected behavior. Or am I missing something? Perhaps the use of OldValue will help. subsum.ControlSource: =Nz(Sum([Amount]);0)+IIf([Dirty];Nz([Ctl_Amount].[Value];0)-Nz([Ctl_Amount].[OldValue];0);0) Note: I only tried...

A copy of the pointer => This is for me irrelevant in terms of time. However, I use the interface to show that the object reference will not be changed. For me, this is worth more than the time that may be needed to create a copy of the reference. Tried it out briefly: Private Function...

Perhaps even activated Name AutoCorrect options can help. Or: Perhaps it helps if you only switch to the new naming at the beginning using views and only change the tables directly later. Maybe you'll get a few ideas from this video:

Why should I use ByRef if I don't want to change the reference? ;)

Access add-ins are not loaded when Access is started. It is only loaded when it is called up via the usual entry in the add-in menu or from another location. See in registry: Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Menu Add-Ins What do you want to use your add-in for...

In my opinion, this is not possible - at least not in a stable way. The entry with UsysRegInfo is a general menu entry for Access, without any special option to bind it to specific Access files. If the menu entry should not be visible for a specific Access file (application), you could use...

Standard modules cannot handle events. Here I would rather use a procedure to call it, so that you can pass initialization values and don't have to implement them in the class. (This makes it possible to use dependency injection etc.) ' Standard module: Public App as New clsApp 'Class clsApp...

Since I believe that the COM add-in is being unnecessarily reloaded every time clsTranslation is instantiated, I created a GitHub issue to track the problem: https://github.com/joyfullservice/msaccess-vcs-addin/issues/622

[OT] Note: There is a simple way (video) to set VB_PredeclaredId = True without using an additional function or editing the exported text file: Write Attribute VB_PredeclaredId = True at the beginning of the codemodule in the VBA editor. It will be marked as an error. But that doesn't matter...

Alternative: If you remove the line modCOMAddIn.ReloadRibbon in the LoadLanguage procedure of the clsTranslation class, the COM add-in will not be unloaded and the ribbon will not disappear. The add-in is unloaded/loaded too often. I would change it like this: Private Sub...

The watched behavior would confirm this. :)

This is a strange behavior of Access if set startFromScratch="true". (Tested with Version 2503.) When a COM add-in (with ribbon) is unloaded, all (?) ribbons of COM add-ins disappear. This must be a feature ;)

I can reproduce the problem with your DB. This is the problem. Problem in the code: clsTranslation.LoadLanguage If RibbonLoaded Then ' Export strings to json file for use in the ribbon. strPath = GetInstallSettings.strInstallFolder & PathSep & "Ribbon.json"...