Recent content by John Sh

Thanks Ken. That sounds like a good idea and easily adaptable to my code or CF. Many thanks to all responders. John

In the form below I want to colour each row depending on the content of the "Notes" field. If I use conditional formatting in multiple mode, after a few rules the formatting of the notes field disappears. I have tagged the controls to respond to code but the entire column is coloured. Clicking...

Thanks for that. I'm using .Jpg exclusively and so far have had no problems. The images I display in Image control are generally 1 to 2mb as anything larger takes too long to load. The larger,13mb, jpgs are displayed on the default Windows viewer, and I don't have images in my reports.

The biggest problem is it would have to be installed on each user's computer, so it looks like WIA is the go. Thank you.

The image size is actually set to 1800 x 1200, width x height. They are all in landscape orientation. "Better" would be if the image mb size was more in keeping with the external software size of 1.7mb instead of 99kb. As for "That way users get the best of both worlds.", the difference in...

I have a situation where I am adding bulk .jpg images, 2 or 3 hundred at a time, to a folder for display in access in an image control. If the images are too large, 3 or 4mb then they take too long to load Using the software below to resize an image is reducing the mb size of the image even when...

A clarifier. Tempvars!genus will never have quotes, double or single, in the string. Genus is a scientific name and is mostly Latin and never has quotes. Species is of similar vein, but in cases where the actual species has not been derived and accepted, a species as in my example, with "Sp." is...

Thank you. I have implemented arnelgp's solution and it works seamlessly.

Thank you. I had tried a few variations of that but not that particular one. John

I fave an sql string that takes it's input from a couple of tempvars. The input for one of the tempvars is Sp. 'Yarawah' from a table field, so the tempvars.value presented to the sql string is "Sp. 'Yarawah'" The single inverted commas are part of the scientific name. db.execute crashes with...

That's exactly why it's in there.

I wondered how long that question would take. I am scanning about 14000 jpg files and the same number of nef files. I recover the file name and the full path to each file using a recursive search. If I search an external drive, that has a full copy, it takes about 30 seconds but connected by...

Removing the docmd from the load event and placing it after the loop statement looks a bit tidier. Private Sub CloseMe() Do DoEvents Loop While Not bOut DoCmd.Close acForm, Me.Name End Sub

I don't think that will work. there is nothing to keep the form open That doesn't work. There is nothing to stop the code running past the end sub of the load event. Calling the loop from the load event effectively halts the flow. John

A simple work around. The form is now popup on modal off and opened with Public Function Messenger() As Boolean DoCmd.OpenForm "messenger" Messenger = bYN End Function I have modified the form's code to become Option Compare Database Option Explicit Private bOut As Boolean Private...