Recent content by John Sh

"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

Thank you both. I'll play with it although I did try a bitmap and still got b/w. It seems there is also a way to do this with a png but it's a bit complicated according to GAIgle. John

3. The problem is that when you use an aggregate function in the SELECT (e.g. COUNT, MAX, MIN, etc.) you need to use a GROUP BY if you have other fields in the SELECT. That means instead of DISTINCT, you need to have a GROUP BY that contains all the other fields in the SELECT that are not in...

Public Function getBoxContent() oDB.Execute "DELETE * FROM counted", dbFailOnError sQry = "INSERT INTO counted ( Family, Infra, box, collection, Specimens ) " _ & " SELECT DISTINCT A.Family, A.infra, A.BoxNo, A.Collection, Count(A.BoxNo) AS count " _ & " FROM boxes...

How? According to all I have read, the only way to have a coloured image on a button is to use a "Shared" image, not embedded. I have tried jpg and bmp with the same result. If you use this on a form with a number of controls, the flicker when mousing over is unacceptable. John