Hi Experts,
10 years ago or so, I wrote a small Access app (single user), that I've used regularly ever since without flaws, where I've also used the Access Switchboard.
For 2 weeks now, i've been getting Class not registered on line
Set con = Application.CurrentProject.Connection
This is using the original Acces built-in switchboard f\code.
Any ideas will be appreciated.
Do you compile the code and compact the DB on a regular basis?
Can you tell us a bit about the conditions under which this error occurs?
I have long since abandoned the Access switchboard because of issues like this, and the inherent complexity.
(VBA Code, Dedicated table, Custom form/control Properties Functions, Limited design changes ...etc)
Twice, I got "confident" and tried to "customize" the switchboard, ...both times I lived to regret that decision...
I am sure there may be a simple solution here, ...
But I have never had a situation where the switchboard manager had an advantage over a Menu system I could create my self.