Search results

You might be pleased to hear that in current VB.Net you can create a real property by just adding the "Property" keyword to a Public variable declaration to get a full fledged Property without writing a getter/setter. Public Property YourPropertyName as PropertyType

Does your .NetLoader also support connecting the even sinks? If not, you should mention that one will lose the ability handle events with Late Binding. - With many objects/libraries this can be tolerated but with some it is a complete deal breaker. I did a presentation on using .Net libraries...

When SAP bought Sybase in 2010(?) they rebranded Sybase ASE as SAP ASE and continued development, albeit slowly. I've got a customer who is just now in the process of upgrading their fairly old Sybase database server to SAP ASE version 16 (probably v16.1). SAP ASE 16.1 was released in 2023 and...

Am Format just determines the visual display of data but not the actual data stored in the database. The Date/Time data type always stores Date and Time. See my post on this topic for further info on how to deal with Date/Time data...

Do you have "Sticky Keys" turned on in the Windows Accessibility ("Ease of Access" in Win10) settings? If yes, pressing [Shift] twice will activate a "holding down [Shift]"-mode in Windows until you again press [Shift] twice. This will cause exactly the behavior you are describing. However, it...

After reading ******** post, I'm at a loss. What purpose does this serve? @MsAccessNL, does your approach provide any additional benefits? When is the announced video coming up?

I suggest you first start by creating a pass-through query manually with your connection string and a super simple query like "SELECT * FROM ATable". If this works, you can try to replicate the manual approach with VBA and then build the query you actually want to use.

I have some doubts whether OpenDatabase works with an ODBC connection string. If it ever worked, it probably was part of the ODBC Direct functionality, which was removed with the switch from JET to ACE in A2007. You can check the DBEngine.Errors collection for a more meaningful error message...

One should rather check whether Access is 64bit.

This is of fundamental importance. You should have included this information in your very first post because people gave you a lot of very good advice which, as it turns out only now, is not really applicable in your case.

RegAsm? Did I miss something? Up until now we were discussing RegSvr32 to register the COM server. By default RegSvr32 will only register the library at system level (DllRegisterServer) which requires admin permissions. However, if your DLL supports user level installation in its DllInstall...

With the standard Windows permissions an ordinary user should also be able to register a DLL just for himself without elevated permissions. (Not in the System directory of course)

You can! Access will only be able to visually display the first one in Design View, but in Report or Print View all three will work as configured.

Well, sounds nice, but can you control (automate) those other applications in any meaningful way?

@ClaraBarton , if you can match the records in the form "somehow" then you could also use the same matching strategy in a query and then simply use the query as recordsource of the sub form.

Do you just mean the query itself worked, or did you also export it to CSV?

The table Job has multiple Attachment columns. Aren't those structurally also Multi Value Fields?

You should keep in mind that even if your client code aborts the HTTP request after 20 seconds, the server might still successfully complete the operation after 20+x seconds. So, make sure submitting duplicate requests does not create some sort of chaos.

I researched this once but didn't do any real implementation work because I found an existing tool that did exactly what I wanted (sync the Outlook address book). AVM published several API specs for communicating with the FritzBox. https://fritz.com/en/pages/interfaces There is also a number...

@dalski, if I would saw off the head of your hammer, does it reduce *your* ability to use a hammer? No, it just reduces the capability of the hammer.