Search results

It seems not. Marital statuses possible in most jurisdictions would be: Single, Married, Divorced, Widowed There may be several more, depending on jurisdiction and context.

Try to find and eliminate the cause of these volume fluctuations. It might be a defective microphone. Also check and experiment sensitivity and noise cancelling settings of the microphone driver/software. Your wife should also observe herself, whether she changes her position relative to the...

SELECT TABLE_CATALOG ,TABLE_SCHEMA ,TABLE_NAME ,COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'YourKnownColumnName' This works with a number of database systems, including Microsoft SQL Server, which support the INFORMATION_SCHEMA Standard.

The VBA environment is not suitable to display Unicode characters, which are not included in your current character set (ANSI codepage). - From your original problem with the three-dot-character we know that it is not included in your codepage. Not exactly. The core characteristics should be...

It's the third time you ask this question without providing much detail. Without you providing further detail on your requirements and intentions, it is unlikely that you will get a more substantial and suitable reply this time. Your previous posts got some short pointers to possible...

And the regex would be correct because it actually *is* an URL.

EAGetMail is a commercial 3rd party component. You buy a license, then download and install their setup. After you did this it should also be available in Microsoft Access/VBA. They even have a 64bit edition of their component. So, I don't see a reason why you couldn't use this component if you...

You mean the "Microsoft CDO for Windows 2000 Library"? That does neither contain a CDO.Session nor a CDO.Inbox class. This CDO library is only meant to send emails, not to receive them.

Attend and find out. ;-)

The environment variable UserProfile will give you the beginning of the path including the username. Dim UserProfilePath as String UserProfilePath = Environ("Userprofile") Dim abre abre = Shell("explorer.exe " & UserProfilePath & "\Documents\Backups", vbNormalFocus)

Yes: "(Access 2007 - 2016 file format)"

1.) The two windows are not of the same version. The blueish window in the front is Access 2007, the white/grey window in the background is at least Access 2019 and might be even the most recent version of Access 365 as of today. 2.) You do have nearly the same number of icons. Actually, I see...

Here 🙋‍♂️ I do that occasionally. But, IIRC, this would already trigger the capitalization issue if class name and variable name don't use the exact same capitalization. So, it would be tolerable if your code would change this unintentionally.

Of course you can declare an object variable ByVal. - However, this will only pass the pointer to the object by value (as a copy), not the object itself. - It is not possible to automatically "copy" an object. You would need custom code tailored to the particular type of object to copy an...

The compiler "determines" nothing of the kind. Why would it? It's your job to define the function and with it the types and passing mechanisms for its arguments. - Which is the default behavior I don't know. I acquired the habit of explicitly stating the passing mechanism in the method...

Your challenges has two different layers. The first layer is the low level handling of COM Port communication. The sample @arnelgp linked to is a good starting point and might be able to cover this for you completely. The next layer is communicating with your external display. To do that you are...

You are invoking DCount without any criteria. It is just counting *all* ProdOrderID in SearchPOQ. Use the Criteria argument of DCount to filter for the currently entered PO#.

Unless I'm mistaken, the export #56 from msaccess.exe is just a file dialog to select a file. There are documented and supported solutions available for that purpose. Thus, I would recommend replacing this old, never officially supported API declaration with a supported alternative, e.g...

There are several ways to achieve this. regasm /u should be the easiest. Of course, you can also delete all the registered COM Interfaces (Classes) from the Registry manually or with a script. You need to know their names and CLSIDs then though. Also be aware, that COM Interfaces can be...

I strongly second this recommendation! If someone figured out the username/email/password combination you used *anywhere* (incl. AWF), they will try the very same combination on a long list of sites (Paypal, Amazon, Microsoft, Ebay, you name it). If it matches anywhere they will use it to their...