Search results

Thanks David. My description maybe misleading. Firstly, I am displaying 70 mb NEF files that Access cannot handle, so have to use external software. I need to be able to display the images in the default viewer on various computers, so have to be able to determine the default for each machine. I...

Thanks. I'll give it a try.

I am using the following code to open a picture viewer via vba oShell.NameSpace(0).ParseName(sPath).InvokeVerb "Open" Then this code to close the viewer Dim Exe As Object For Each Exe In GetObject("winmgmts:").ExecQuery("Select Name from Win32_Process Where Name = '" & sViewer & "'")...

First select control B then copy the format in control B with the format painter and paste that into control A. I then had to alter the formats in control A from "xxxx" to [control B]= "xxxx" I copied the "control B = " and pasted that to the front of each condition. This seems to have worked...

Firstly this is a continuous form and, yes, the conditional format of control B is dependent on the text in that control. I'm trying to mirror the CF of control B in control A. It looks like I'll have to duplicate control B format in control A. I thank you all for the quick response and...

Is it possible to format one control to be the same colour as another control such as control A = RGB() of control B so that control A is always the same colour as control B without having to write an expression in control A for each possible state of control B with the same colour in each'

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"