Recent content by RonPaii

Or by changing the Enum you can make it simpler. Public Enum eDelimiterType Public Enum eDelimiterType NoDelimiter = 0 DoubleQuotes = 34 Octothorpes = 35 SingleQuotes = 39 End Enum Public Enum eSeperatorType Comma = 44 Pipe = 124 SemiColon = 59 Tilde = 126...

You can directly use your enums, making the code more readable without comment. Public Function fgetLBX(lbx As ListBox, _ Optional intColumn As Integer = 0, _ Optional Seperator As eSeperatorType = eSeperatorType.Comma, _ Optional Delimiter As eDelimiterType =...

Instead of a bunch of functions and the slows they will cause your queries, consider normalizing your data so you can easily control the sort and handle future changes.

If you sort the field directly alphabetically i.e. without the val function your sort will come out as follows. 01, 02, 1, 2, 3, 4, 6 but if you add something like 10 then you will get 01, 02, 1, 10, 2, 3, 4, 6 if you are looking for something like 01, 1, 02, 2, 3, 4, 6 You will need to...

It will only change the politicians not the corruption. Plus term limits do nothing about the corrupt bureaucrats.

Change all your cases from "[" & DateField & "] ..." to & DateField & The brackets are not needed unless DateField has spaces or special characters or is a keyword. Let the calling function deal with those issues.

I have had issues with v3 fixed by setting LeasingMode to none on server share with Access BE files. It does slow down BE. With this setting I rarely see corruption problems and that is with up to 35 users hitting the same backend. To disable LeasingMode on a server share (not on the entire...

Gustav, I apologize for the confusion about your module requiring a reference to Microsoft ActiveX Object Library. It is only required by my login module. I updated the code in GitHub to remove any confusion with anyone looking at my version. I also added your notes about random numbers.

So is bcript.dll obsolete?

Gustav Brock has a cryptology module for Access using bcript.dll and Kernel32.dll which I believe is available on all modern versions Windows. The only reference you need is Microsoft ActiveX Data Objects 6.1 Library. (c) Gustav Brock, Cactus Data ApS, CPH...

You may find that an individual may become a business IE purchase something for there home business. Consider storing required information for a contact in the contact table and everything else in a property table. This will allow you to add properties in the future without changing your tables...

As a government gets more powerful, money will flow to corrupt politicians who provide benefits from that government to the highest bidder. The only way I see to reduce corruption is to reduce government.

Are the files in a public repository, or do you need to provide credentials to Claude?

Have you look at used laptop, tablet or phone screens. They would be cheap or free.

I ask Copilot, it said it could handle that much but cannot open an accdb. It recommends giving it .bas/.cls uploads. As for speed I think you would have time to make a nice dinner for all your friends while it works on it.