Recent content by John Sh

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

Over the years I have received much needed help from many on this forum, so now it is my turn. This might be an old trick but I put it here anyway. To turn an ordinary form into something a bit more professional looking, I have simply placed a command button over the entire form. Set the button...

So Simple. Ta muchly.

This is best explained in pictures, see below. I have a simple form with two buttons. I would like the form to encompass the buttons but not spread out over the page. The screen shots represent my latest attempts to correct this problem. I am running Access 2016 on windows 11. This is what I...