Avatar of al4629740
al4629740Flag for United States of America asked on

MS Access Error

I have an access program that I am trying to open from a different computer with a more updated version.  It seems like my first error (attached) is that it cant find WinWord when starting the program.  This error occurs when I open Access for the first time on the new computer.  The question I have is how can I fix this error by telling the program where MS Word is located?

error.png
Microsoft Access

Avatar of undefined
Last Comment
Kelvin Sparks

8/22/2022 - Mon
Kelvin Sparks

You need to set this as a trusted application through the Menu. Find the Access File menu (when you are open - choose Options and then Trust Centre, and then click the Trust Centre Settings button. Set the trusted locations for your MS Access location and those of the databases that you open.

Close and restart Access

Kelvin
John Tsioumpris

I guess a way is to parse registry for locating winword : https://www.actualinstaller.com/help/winword.html
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\Winword.exe

Open in new window

To read the registry : https://docs.microsoft.com/en-us/dotnet/visual-basic/developing-apps/programming/computer-resources/how-to-read-a-value-from-a-registry-key
Now 2 questions arise..
1. You need probably VBA to do it ...i am not sure if you can implement it on Macro Level
2. Why use such kind of early early binding...just start your application and use late binding to use the Word functionality..you can check the installation presence like this
Dim obj As Object
    Set obj = CreateObjectType("Word.Application")

    If Not obj Is Nothing Then
     'You have Word so use late Binding to work with it
      set obj = Nothing
    else
      ' Not Installed
     End If

Open in new window


Gustav Brock

Try to replace the direct call with a more generic:

Start Winword

Open in new window

Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER
al4629740

How can I find where this code is being ran to make the change.  I opened the VB editor but I'm thinking there are some startup properties where this can be found.  As I search for anything that says RunApplication or AutoExec, I don't see it.   I'm not the best at Access so any more detail would help.  
Kelvin Sparks

If a macro is called Autoexec, it will run on startup automatically. Holding down Shift while starting Access bypasses that. If you don't want it to run at all, rename the Macro to something else, and call it when you need it.


Kelvin
ASKER
al4629740

That works, but when I go to tools and macros to find the Autoexec macro, I don't see it.  Even when I look in the VB Projects window I don't see that Macro
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Kelvin Sparks

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Kelvin Sparks

The shutter bar is also called the Navigation Pane.