Query counting similar items from several fields

[isladogs]

Whilst it is indeed a workround, the outcome is I find very successful.
Its also extremely fast in use

The Flexgrid control can be used for this kind of application but AFAIK its never been updated to work with 64-bit Access. Peter Hibbs has loads of Flexgrid examples both at UA and elsewhere all with very detailed documentation. Several examples here http://www.rogersaccesslibrary.com/forum/RSS_hibbs-peter_forum21.xml

 

[MajP]

I have used the Flexgrid, but it is painful. Hard to register, not very user friendly, not portable, and limited. A native control could solve those issues. These other techniques work well, but are not the easiest or intuitive for most people to implement. A native unbound data grid would be a common intuitive solution to overcome many of Access's GUI limitations.

Another technique I forgot to mention is building an on the fly in-memory ADO recordset. This way you can have an editable recordset and bind it to a form, then you can add and edit, then use it to populate a normalized table.

 

[isladogs]

I agree with all of that.
The workaround does work well but isn't easy for anyone new to Access to implement.
About 5 years ago I was just beginning to get the hang of Flexgrid when the 64-bit issue led me to scrap everything I'd done based on it

By chance, I'm currently working on using a disconnected ADO recordset which is what I think you're referring to. I'm using that approach with a split no strings database. Again, not intuitive, at least for me, but its an interesting approach.