Search results

You have piqued my interest so fire away

Thank you. I have implemented IMB's approach. I have converted all of my sql strings to this format with a couple of search and replace passes.

I like the concept. You have in instant visualisation of you mistakes, or you don't make them in the first place. Thank you. John

I know you professionals like every thing to be tickety boo, but! I have inherited a "system" that was thrown together in the 70's and grew like topsy from there. To say it is a poor design, implies that there was a design process in the first place. That being said, it is what it is and I have...

I do usually use a similar format. Vis variable "sQry" is declared private in a module that holds many SQL strings sQry = "xyz" odb.execute sQry, dbfailonerror Once the string is working correctly I will transfer it to this module in that format. I prefer to get things working in a separate...

To achieve the results I need, I have to do a series of findfirst operations and it simply takes too long. Using SQL is many times faster.

Thank you. I should have realised those spaces were missing but the harder you look, the easier it is to not see. The second part of my query was how to include the "Notes" field using the sStr variable. E.g. Public Sub inToDisc(dFamily As String, sFamily As String, nAccno As Double, sStr As...

In the SQL string below, the "Main_Family" field needs to be controlled by the variable "dFamily". I need to run the same basic SQL with the "Family" data going into different fields.. This occurs n the "INSERT INTO" and "WHERE" clauses. I have tried fields(dFamily) to no avail AI has been no...

Sorry Docman. A simple typo has led you astray. I did, of course, mean the laccdb file and not the accdb file. My 86yo fingers don't always do what my 86yo brain thinks it's telling them. John

Hi Docman The drive X only holds the data for my development files so no damage done to the active files. X was disconnected, and the main computer off, for about 4 days and a computer restart was done, with X connected, but the accdb file persisted. Possibly the main computer being off would...

I had a situation where the external drive, holding the remote data files, was removed before Access was completely shut down. This left the laccdb file on the drive and doing that which it was designed to do, lock up Access. I was unable to do a compact and repair, nor was I able to remove the...

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