Recent content by Josef P.

2 Tasks: 1. generate filter expression (where condition) - When changing the length option group, supply the textbox for manual filling with the appropriate value. - generate condition string with textbox and option group of section 2. set the data source of the list box with this filter -...

Ivercy also supports the MSSCCI interface. Alternatively, there is also OASIS-SVN or the open source application msaccess-vcs. I now use msaccess-vcs (mostly with git/TortoiseGit) and no longer miss the Access VCS add-in that ran until Access 2010. msaccess-vcs has the advantage for me that I...

Note: A useful article on the topic of member variables: https://nolongerset.com/this/

If I have confusable variables [TotAsts and TotAssts] in the code, where I even have to scroll, then (in my opinion) my main problem is not where I declared the variables, but the code design itself. If I understand you correctly, you are arguing that exactly these confusable variables are...

Maybe it would have helped if you had also read the 2nd sentence after this one ;) If I declare the variable directly before using it, I know it quite precisely. However, if the compiler then complains, I've done something wrong. It's not the variable name that's wrong, but the procedure is too...

It shouldn't really matter which variant you use. I simply claim that the code is too long as soon as it makes a difference. In C#, I only use the "closest to first use" variant (with var and direct assignment). var parameters = new List<IParameter>(); However, this is not possible in VBA. I...

In principle, this should work - just as a frontend could theoretically be located in a network directory. However, I would not recommend this variant. For example, it could be difficult to update the library if it is still accessible. If you use the "add-in variant" as shown in #18, you can...

An ‘EventBridge’ would allow late binding. Class: Public Event Commit(ByVal NewValue As Variant) Public Event Canceled() Public Sub RaiseCommit(ByVal NewValue As Variant) RaiseEvent Commit(NewValue) End Sub Public Sub RaiseCanceled() RaiseEvent Canceled End Sub Init a reference from...

Note: I know .acf, .acm, etc. from the text export via the Microsoft Access SCC Add-in (I think this was available until Access 2010). However, you can also give these files the extension .txt and they can still be imported with LoadFromText.

Are you looking for the IBAN position? public Function IbanPos(ByVal TextToCheck As String, Optional ByRef Iban As String) As Long Const Pattern As String = "(AT(?:\s*\d\s*){18}|DE(?:\s*\d\s*){20})" Static RegEx As Object Dim Matches As Object Dim Match As Object If RegEx Is...

Why do you have 4 controls if you only use the value of one control as the filter value? Maybe that's what you want: Private Sub txtCity_KeyDown(KeyCode As Integer, Shift As Integer) SetFilter Me.txtItemCode.Value, Me.txtItemDescription.Value, Me.txtPPU.Value, Me.txtCity.Text End Sub...

You could also create a COM-Add-In for Word with twinBasic, then you stay with your known language. Note: ADO.net is completely different from ADODB or DAO. If you want to familiarize yourself with .net, I would rather put the effort into learning C#.

T-SQL does not need the brackets, but I don't think that's the problem. ... FROM dbo.T_Inspections LEFT JOIN dbo.T_Receipts ON dbo.T_Inspections.Job_Id = dbo.T_Receipts.Invoice_Number LEFT JOIN dbo.T_Payments ON dbo.T_Inspections.Job_Id = dbo.T_Payments.Job_ID Is the database...

During the conversion, the TextFormat property remains, which Short Text cannot do anything with. => With CurrentDb .Execute "UPDATE " & tableName & " SET Umsatztext = Left(Umsatztext, 255)", dbFailOnError .Execute "ALTER TABLE " & tableName & " ALTER COLUMN Umsatztext TEXT(255)"...

[Application.References.AddFromFile] As these are all registered libraries, you could alternatively use the AddFromGuid method.