Recent content by Nixversteher

The code you have shown suggests that the dll does not need to be registered as it only provides standard functions. However, it must be located in a path to which your application has access at runtime, i.e. if it is located under "C:\Klax\WKNL\" in your case.

the code from ebs works, only you have to adjust the function Public Function HijriToGregorian(AnyDate As String) As Date Dim lDate As Date VBA.Calendar = vbCalHijri lDate = CDate(AnyDate) VBA.Calendar = vbCalGreg HijriToGregorian = lDate End Function

if this is now a Utc-date (more exactly 01/23/2023 00:00:00) then only the function "ParseUtc" in your JsonCovertor.txt from your input post should be called.

Hello Yes you could evaluate dd events in Access, the question where the data comes from (outlook, excel, thunderbird,...) is not the first question, but how deep you want to deal with the problem. Access itself does not provide any functions for a fully functional dd. But over some control...

I believe that this is already possible. In the simplest case a form timer that reads the pixel under the mouse. Attached is a simple example, based on your sample code above.

Byref means that the pointer of the variable is passed. a "z =Array(varptr(..), Varptr(...), ...)" would be equivalent to that. But VBA can't do anything with pointers. But it is possible, with a small helper function and a completely insane manipulation of a variant data type. Therefore it is...

That's right, the url can now be much longer than the 20xx characters I mentioned. But I think the free version of Google Translator only accepts up to 5000 characters of text.

I think there can be a maximum of 2048 characters. However, since each character of the plaintext can be split into up to 3 escape sequence characters, the plaintext should have fewer characters. Urlencode without excel.

yes, newer cameras and phones should be able to do this automatically. but the standard exif is a bit older, and back then this was probably not so easy to do due to technology. so the display software has to rotate the images correctly. hi colin in your shown example it is cool that the...

yes, that's right, once again I didn't have my glasses on. But I don't know what you mean by the other 18 propertys. The typo-ridden example of mine only changes the Exif tag for orientation. But there are more than 18 Exif tags (.Properties ("ID")). The code fragment also does not change the...

Yes I have. And it worked for me.

No. You do not need any additional software. The following example (code fragment) changes the exif tag for the orientation: With New WIA.ImageProcess call .Filters.Add(.FilterInfos("Exif").FilterID) let .Filters(1).Properties("ID") = 274 ' = GDIP...

Windows and the other programs rotate the images when displaying them using the exif tag without changing the file. The correct positioning in Acces you have to program accordingly. Load the image into a wia.imgefile, read the corresponding tag, rotate/mirror the image according to the tag and...

With WIA you can read and write Exif data.

This is an experiment (only 32bit) with your subclassing title bar double-click code where the editor can be open (hopefully). But I think if you want to use subclassing it is better to outsource this to a dll using a suitable language.