Search results

For a while, Access seemed to be behaving until I changed the text below, from Me.btnShow.Caption = "The Family '" & Me.txtFamilyIn & "'" & vbCrLf & _ "Is not on the Taxon list." & vbCrLf & vbCrLf & _ "Please check the hispid sheet, for the...

Currently running 2016.

Hi George. I edit my SQL in the standard VBA editor. I'm not aware of the "Monaco Editor". Should I be? John

I do have quite a bit of Access SQL and , so far, it doesn't appear to have been affected.

KitaYama. Thanks for the comprehensive list. My aim isn't so much to avoid using Edge, I steer well clear of it. It's more part of debloating Windows. My understanding is that in Europe you can remove edge without causing problems. There is a switch within Windows that enables that. One can...

I think Chrome is a licence for Google to steal your data. Never tried Brave. I've been using Firefox since it came out and never had a complaint. I'm marking this as solved. Thanks to all that contributed. John

An update. I had turned off a couple of windows functions before the odd behaviour and a couple of days ago I deleted MS Edge. The computer, generally, started doing odd things so, today, I reinstalled Edge and all seems to be working as expected. Popup/modal forms are again on top and some of...

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