Am unable to use any of the controls options like text box, chart etc. on forms and reports.
When I click on them the below error message pops up (see screenshot attached).
Microsoft Access can't create any more controls on this form or report. If you have deleted controls from this form or report in the past, you may be able to rename the form or report and then add more controls to it.
Tech Support Guy System Info Utility version 1.0.0.9
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 32 bit, Build 7601, Installed 20140101000000.000000+000
Processor: Intel(R) Atom(TM) x5-Z8300 CPU @ 1.44GHz, x86 Family 6 Model 12 Stepping 3, CPU Count: 4
Hi, welcome to forum.
I'm okay with VBA but not in Access, never seen an error like this.
Is the installation correct? Report not read only? Just some ideas
I have searched everywhere and no one seem to have experience it.
I believe it was installed correctly. Am able to create tables and queries.
I can open reports and create reports from tables and queries.
However, when creating from a selected table or query an error pops up but the report is still created.
I will post a screenshot of error.
Can you create a userform?
If you cannot create anything at all, then you should check the Tools References in the VBA project, are all the references set? Have you checked that?
Have you tried the database repair tools and perform a thorough check and compact etc etc.
I don't know if you have done this but there is a limit of 256 controls maybe you've been busy adding and removing controls; the counter even if you deleted all will keep on counting.
Maybe that could be the problem.
I'm using 2016 and don't have 2010 anymore on this system to test
Sorry I meant ms access (Microsoft Access).
About 5 boxes of A references were enabled so I enabled all of the other boxes. The issue still occurring after doing that.
I tried repair and it says msado21.tlb version 2.1 needs to fix. I attach a screenshot.
Issue still occurring.
If I read the error correctly that's the whole problem, there's a missing link to for the database non existent table. Or missing control
This was my first answer (disregard) You either miss data or the table has been renamed and the links not corrected. You'll have to dig through it and see where it's coming from. Maybe you're using a linked table
Open Access in Safe mode and then step though everything.
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!