Search results

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"...

Thanks for doing the research. :) I now have a guess as to why the horizontal ellipsis is used instead of the three dots. These are not displayed in the ribbon. However, if you enter "Build As... " (with a space at the end), the three dots are visible. Which font is used for the ribbon? The...

That's interesting. Then ChrW(8230) is not a fix. ;) ChrW(8230) delivers the points on the line for me (in Immediate and also as value of a textbox). Shouldn't Unicode look the same everywhere?

AddCtl "btnBuildAs", "Build As" & ChrW(8230), _ strSupertip:="Build from source files to a new name or location." I suggested this code as a fix because it gives (hopefully :)) the original expected result. "Build As..." (3 dots) would also be equivalent in terms of content, but is...

Tested with original downloaded file: no compile errors Code: AddCtl "btnBuildAs", "Build As…", _ strSupertip:="Build from source files to a new name or location." Note: "…" = Chr(133) (codepage 1252) => Which codepage are you using? Is Chr(133) perhaps a different character...

Have you read the code? ' correct logic, but will not work with example data 'Set rs = db.OpenRecordset("select * from qrytblUsuariosJSON where numFactura = '" & Replace(numFactura, "'", "''") & "'") ' => without filter Set rs = db.OpenRecordset("qrytblUsuariosJSON") I assumed...

There is only one folder for me. Git does the rest. Git is a distributed version control system. In principle, the local repository is checked in first and this is later synchronized with a repository on a server. msaccess-vcs creates an index file with hash values in the local folder. You can...

It would be very helpful if the sample data matched the content and all data fields were available for the JSON fields. Test-Code: Private Sub Test() Debug.Print GetFacturaJSON End Sub Public Function GetFacturaJSON() As String Dim FacturaList As Collection Dim FacturaJSON As...

I was a little curious => Code to create backup of VCS folder: Option Compare Database Option Explicit ' insert this procedure name in VCS option "Run Sub After Export" Public Sub RunAfterVcsExportProc() If MsgBox("Create backup of VCS folder?", vbYesNo, "VCS (Run After Export): " &...

That will certainly be informative: https://www.accessforever.org/post/access-devcon-2025-agenda Who is actually the referee for this duel? ... Karl? ;)

To follow up on the idea of creating a backup of the folder: For example, you could set a procedure name in the add-in option 'Run Sub After Export' to call a procedure from your application that copies the directory to a ZIP file. Note: In my msacces-vcs fork, this would also work via an...

[OT] Maybe this will be a longer discussion, so I opened a new thread. :) https://www.access-programmers.co.uk/forums/threads/version-control-for-ms-access-using-the-msaccess-vcs-add-in.333778/

To prevent the thread from Does Microsoft Access 2024 (Professional Plus 2024) Export Forms as Text for Re-Import? becoming too OT, I'll start a new thread. The msaccess-vcs add-in is particularly helpful when using a version management system such as Git, Mercurial, etc. You can of course...

Exporting or importing may be the least of the problems. Depending on the project, modifying a form or its controls in the text file can be a challenge. ;) Example: Version =20 VersionRequired =20 Begin Form ... Begin Section Height =5442 Name ="Detail"...

If VBA.Split works, there will be another Split function somewhere in your code or in a linked library (VBA references). => write Split (without VBA. before), set cursor inside the word and click Shift+F2. This should bring you to the split function.

Note: Private procedures can be started by placing the cursor in the function and pressing F5. It's a habit of mine not to make test code publicly accessible. Hopefully I won't forget to make it public in future examples. ;)

1. Let's simply rule out Split as a direct cause: please test the attached file. 2. What do you have to change in the attached file for the error to occur? Note: I had a similar error message several times when customizing msaccess-vcs with a 64-bit access when I used string arrays as...