Search results

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.

Why do you attribute a change in Microsoft Outlook to Microsoft Access? The absolute only built-in method in Access *potentially* affected by this change is DoCmd.SendObject. I say "potentially" because SendObject always required a (Simple)MAPI compatible email client. It always was the...

MsForms is the standard UI library for VBA and it is fully functional in all VBA enabled applications; so all of Ms Office. The only reason why it would not be recommended for Access is that Access itself has its own forms which are better suited for most use cases.

Can it be as simple as adding 7 months to the date to get its fiscal year?