I also enhanced the original utility by Allen Browne so it now works 'both ways': SQL to VBA and back again
Did you make yours work with action queries?
I also enhanced the original utility by Allen Browne so it now works 'both ways': SQL to VBA and back again
Not for the main functionality.
There is one UPDATE statement but that's only where users want to save the combo setting on the VBA tab as the default.
Suggest you look at the code if interested in knowing more
Just a thought.
! was told, in general, the answer is a query.
I use queries wherever possible. I use code, when I can't do it with a query - perhaps the query is non-updatable.
It's hard to get the precise percentage, but a good deal of my code is defensive - controlling the look and appearance of the dbs, checking for legitimate values, confirming that user input and so on.
! was told, in general, the answer is a query.