This would be a great addition instead of what I currently do which is putting a label above it with all that column names, but doesn't really work now for me due to DPI issues ect.
What I'm doing is creatng a VB.Net DLL and adding it as a reference to the Access DB. Create and I/O interface, and get all the riches of Visual Studio with Entity Framework, parallel processing etc.
No brainer consider the snail's pace progress of fundamental MS Access functionality.
Joe/Mark, I'll give your suggestions a go, thanks. I also redesigning the Access Front end to be more "organic" (some of the code is 15 years old), to not require dynamically generated (or pre-generated) controls to exist.
Hiding/unhiding existing controls is exactly what I do at present, it's just a real pain to create many hundreds of controls for certain "dynamic" forms to cover the worst case scenarios. Just would be nice and easier to programmatically create the correct amount through code in real time.
If I'm not mistaken, from my quick test, CreateControl only works when you are in design or layout mode not a live mode. Perhaps you could create a form live using CreateControl and save and open it, but what I'm after is having a pre-existing form where you can dynamically add new controls as you see fit in a live situation.
Please correct me if I'm wrong.
11 votes5 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
I can confirm Anders comment, it's a fantastic titbit particularly when you get referential integrity errors and want to know the culprit easily.