Search results

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...

Thanks. I have, in fact, done just that but I have other situations where there may. or may not, be multiple results of the requery. If there is only one result I need the program to progress to the next combo automatically. If there is more than one result then the dropdown is activated. In the...

Hi. I put the two tempvars in there to feed the comboboxes. In real life they would be instantiated in a separate form with the current record's genus and species. The code supplied is just the problem bit, the real code uses the genus and species info to select one, or more, images of that...

I have two problems in the attached sample. 1. If I leave the recordsource statement un-commented, the code goes straight to the "Createdby_Gotfocus" event, runs it then returns to the onload event. Comment it out and the code runs as expected. 2. With the "on error resume next" statements...