Search results

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

FWIW, here is the sub. Called from the current control's gotfocus event with "isanythingthere me, me.nameofnextcontrol" Public Sub isAnyThingThere(frm As Form, ctlNext As Control) Dim ctl As Control Set ctl = frm.ActiveControl With frm .Controls(ctl.Name).BackColor =...

NO, Doc_man. The controls are placed top to bottom and the auto tab goes left to right. I have solved the problem using the gotfocus event Private Sub cboFlower_GotFocus() Me.cboFlower.BackColor = TempVars!colouron If Nz(Me.cboFlower.ItemData(0), "") = "" Or Nz(Me.cboFlower, "") > ""...

Hi Ken. That is the simplest method but we're not working with people who are very adaptable. They will click on every control and expect it to go to the next. I have actually taught them to not use tab because the tab order is not always the next control. Some of the forms have 90 odd controls...

That didn't work because the focus changes when you release the mouse button on the dropdown arrow. You don't get to see the dropdown or select an item.

Thank you all. I finished up using the mouseup event. Obviously the mouse down event works equally well but feels a bit too instantaneous. John