Search results

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

My sincere thanks to all. The brackets have been removed. I find the error messages, in many cases, do nothing but increase the angst. Messages like "Expected bracket" etc are of little, or no, value. I finished up using Arnelgp's suggestion with "Select distinct" added and the group clause...

Thank you. A constructive suggestion is most useful.

This sql string tells me it expects ")". There must be one place I haven't tried and I have no idea where that place is. The problem is in the where clause and specifically after the "And", as I read it. The where clause was originally a "Having" clause but this seemed to be causing even more...

It depends entirely on where you place the "set rs1". If it is placed before the delete * you will have to close and reopen the recordset. A .move first or last will throw an error. Incorporating the "rs1.Move 0, rs1.LastModified" construct will allow the last record to be seen but a subsequent...

And that is where the original problem started. I would, traditionally, delete before opening the recordset, but when it came to a .movefirst in the code, is when that error appeared so I have been wrestling with various configurations to try and solve this. The sample I posted was the last...

I have a simple table that acquires a few records during the operation of a module. After acquiring 4 or 5 records this table is read to indicate where action is required. My problem is that I am getting an error indicating the "record is deleted." Prior to running the module I delete all...

Correct. I set the ANSI compatible SQL some time ago as it simplifies "?" using SQL strings and doesn't affect stored queries. Thank you all for you comments.

I finished up with .Filter = "[Collector] alike '" & sFilter & "%'" This works as required. Thanks again for your help.

Thanks. Much appreciated. John

I'm not really stupid, it just seems that way sometimes. John

I have a list of names in a field "Collector" that can include the names of others in a team, .e.g. "Jones. K. Smith. W." I want to filter this field such that it will return all fields that include "Jones" . I have tried many variations of the code below but .filter always returns "False"...