Search results

I do a compact and repair on close so corruption is unlikely. Also everything else is working as expected. It just starts for no apparent reason and sometimes just stops doing it. Usually restarting Access fixes it for a while. Just a nuisance really, especially when trying to sort a field.

From time to time, in table view. I get this strange behaviour. I am running Access 2019 and still on W10. First image, Open table view. The first field is already highlighted. Second image, select "Main_Family". All fields to the left are highlighted. Third image, select record 107. All...

Thanks for that. My only observation is that "as_date" and "as_String" rely on a "Null" value but don't consider an empty string. Maybe "NZ()" rather than "isNull" would make them more reliable. Function As_text(cur_text As Variant, Optional on_null As String) As String If nz(cur_text,"")=""...

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