Search results

The following code will remove the rotational instruction from EXIF. It actually makes a new copy of the image that displays correctly. The original code was from Isladogs or dev_hut, I looked at so much I forget where it all came from. Regarding images taking a while to load, you need to resize...

I figured this out about 10 minutes after I switched the compute off. My 86 Y.O. brain doesn't always work as expected. By way of explanation, this is the last step in compiling a list of errors in an old DB. We have about 14,000 plant specimens that have a raw image and a jpg image each. I scan...

Noted. Thanks

First, might I say a big thank you to all. Your assistance is invaluable. Why the function? it's the only only to test in the immediate window. It doesn't respond to subs. "Sqry" is a private sub in this module which holds a number of sql strings. I declared it private once, rather than declare...

In the attached sql string, the alias "A" is not recognised at the first instance of "A.accession" "Accession" is a valid field in the table "Discrepancies". If I remove the alias and use the table name I get the same "variable not defined" error on "Discrepancies" I have tried enclosing table...

Thank you, that fixed it. Something to look out for.

I am in the process of converting sql strings to incorporate "select distinct" and also to use currentdb.execute where appropriate. As I understand it, "select distinct" eliminates the need for the "Group" clause. The following code seem to refute that. What am I doing wrong? I understand the...

me.dirty = false did the trick but apart from coding there is no other interaction with the form. I had to leave the filter in place, even though the old records were deleted, because it showed "Deleted" in the bound controls. This is not happening with the filter on. Once again, I thank you. John

I have a form that displays an image depending on the data input to two combo boxes. A small table is created with the image location info and multiple images can be scrolled through. This all works fine until the data is changed. Before adding new data to the table I am attempting to delete the...

This is an old thread but there still seems to be some interest. I was having the same problem and found that stripping the metadata allowed the images to be displayed in the correct orientation. A quick search revealed software from devhut to do the job...

Thank you. I'll give it a try in the morning. Rather than create a new object, I use Daniel Pineault's "Self Healing Object Variables" Look them up here, https://www.devhut.net/self-healing-object-variables/ You create the object once and refer to the same instance of the object until such time...

Not sure where the "amp" comes from but what I posted is a valid hyperlink.

Thank you. I had pretty much come to that conclusion but was looking for confirmation

Hi Jason Lee. I tried using this sub but it errors on the "isnull". "Object can't use this method"

I am currently using this construct to open a word document to a bookmark/hyperlink, "Help" in this instance. FollowHyperlink TempVars!XLA & "The Don McNair Herbarium Data Set.docx", "Help", , True Is there a way to implement this with the "Shell.application", it doesn't accept the second...

Nice touch Jason Lee. Thanks

Thanks Doc_man. I use a combination of Lightroom and Affinity Photo to process my images and only shoot in raw mode, so am well versed in the available software. The access software is required to open a 70mb raw image and a 13mb jpg as both images are stored. FYI. My initial testing seems to...

NEF is the Nikon raw file system, remotely similar to tiff but generally smaller file size. It is unfortunate that each camera manufacturer has their own variation of raw data capture "and ne'er the twain shall meet" I never could work out how tiff can take a 8mb uncompressed jpg image file and...

Works a treat. Many thanks.

I am using followhyperlink to open an 'NEF" image and get this message. If I select "cancel", I immediately get an error message indicating a null value. Turning warnings off has no effect and there seems to be no way to trap the null error except "on error resume next". Is there a way to avoid...