Recent content by sonic8

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