Recent content by John Sh

I think I might have an underlying problem. My Email just started doing odd things which were corrected with a reboot. The compact and repair in my previous post fixed the problem on the fist pass bur subsequent tries have reverted to the second form going behind the first. I will do a bit of...

I'll try to answer you all. I have tried this on another computer and the popup behaviour is normal. I.e popup yes and modal yes, the form is on top and must be closed. Colin. The forms in question are part of a large system. Separating the form is easy. Separating the underlying functionality...

I only have one computer to try it on, so not knowing, cannot say.

I am running Access 2016 on Windows 11 and am experiencing some odd behaviour over the last week or so. Firstly some, not all, of my popup/modal forms are going behind the calling form. To get them to sit on top I have to make them modal but not popup. Secondly when I open some forms in accdb...

"Thufferin' thuccotash"! Thanks Doc Man. I've often pondered the "advantage" of normalisation where the overhead defeats the purpose. Your explanation puts it all into context. This may well be one of those cases but the exercise is a learning experience. John

Thank you all. Obviously "Murgetroid" was used for demonstration purposes and does not indicate a valid field name. Nor does the code snippet represent the final subroutine I also need other fields to link existing data, so this is a bare bones question. That said, the question was answered and...

I have a table, H2, with a number of seldom used fields. I want to create a separate table for each of the fields with table and field name the same as these near empty fields. I.E. if the field name is "Murgetroid" then I want a table "Murgetroid" with a text field "Murgetroid" If I use a...

That's exactly what I was trying to do, in a testing phase.

Thank you Tom I have set the table defaults to "" and had also changed the contents of cboinfra to " ", so with a definite space, just to eliminate the chance of a null I had tried wrapping the [Forms]![Box etc with nz but not the [Boxes.infra]. That made the difference. John

This query fails if the control "cboInfra" is an empty string. The field defaults to "" and I have tried " ". I have tried various placements of "%" to no avail.. Note. The code is generated by Access from the Query designer. SELECT Boxes.Collection FROM Boxes GROUP BY Boxes.Collection...

Exactly. So why are we now at post 15?

Hi Ken. The table "Boxes" is an interim table that collects raw data. The data in "Counted" is also interim data. This data is then compared with data from other tables and finally compiled into the sample table. This exercise collects data from 15000 raw images and a similar number of jpg...

I have attached a tiny sample of the final table. It is 1850 records long. I would be delighted for you to show me how this can be accomplished with a single query. There is at least one error in every record. John

This is just one of a string of queries that generate a table that lists all the errors from an inherited database. Many of the errors refer to duplicate locations of images. incorrect genus and family combinations and a multitude of other errors. The inherited database had only text controls...

Thanks. Already sorted this one out