Search results

The only time I saw that problem was on laptops when not connected.

So the default printer pointing to a non-existent network printer is still a problem? I thought Microsoft had that fixed years ago.

If you want to always be able to recover your customer's DB, you will need some sort of back door. You can have Access send an email with a on-time unlock code, but what if it can't connect to you email server? What if your user changes the email system and address?

Active directory is part of a Windows server setup. It provides authentication and security for all computers connected to it. I don't see how you can provide security on independent computers running simple file sharing or standalone. To do password reset, you will need some type of...

If your systems are on Active Directory, you can get logged user ID from AD and forgo all the password stuff.

If the BE is on SQL server then SMB would not be the issue.

I have been using it for refactor and lint. This week it came in handy for refactoring some C# code that interfaces with the Autodesk Vault API. This API is poorly documented and the public example code is largely outdated.

I forgot vbNewLine is a 2 character sting. Requiring the same treatment as the Null eDelimiterType Public Enum eDelimiterType Public Enum eDelimiterType NoDelimiter = 0 DoubleQuotes = 34 Octothorpes = 35 SingleQuotes = 39 End Enum Public Enum eSeperatorType Comma = 44...

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.