Recent content by Josef P.

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

The use of the (VBA) Split function is perhaps unusual, but correct. (Without defined Delimiter parameter " " is used.) If the compiler error is not marked, the VB project could be “confused”, then decompile would help. Of course, create a backup first.

Double is used in the example to show that the value is a decimal number (a floating point number, to be precise). All data types other than string must be converted to a string when concatenating a string. If this conversion is not explicitly specified, it is (unfortunately) implicit in VBA...

A few examples with the familiar problems: Private Sub BasicPrinciples() Dim SqlCriteria As String ' ' convert numeric values to a SQL string ' -------------------------------------- SqlCriteria = "NumericField = " & 5 Debug.Print """NumericField = "" & 5 =>"...