I have a module, built into an Access form using VBA, which calls the word application object. A typical example is Word.Application.ScreenUpdating = False
This worked fine on Friday, when I left. Now, every time I try to compile, I get Run Time Error 429: ActiveX can't create object. I did...
Beautiful. That was exactly what I needed. I'm so used to just calling it with: Application.ScreenUpdating = False I didn't realize that I needed to call it as: Word.Application.ScreenUpdating = False from MS Access. Thanks!
A common issue I seem to encounter quite often in VBA is that a method or property will not show in the object browser and/or won't compile. I often find that, after flailing around a bit, turning on the correct reference library makes the problem go away. Is there a resource somewhere that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.