HI,
I have an Access DB (.mde) running from a Access 2003 Thinapped.
At some stage, this DB application kicks off a Winword document.
In a all packages installed localy mode, everything is fine.
When I only have Office standard installe with Access Thinapped, I can only get an error message ????
Any idea ?
Many thanks.
Next time you want to help with error, please, describe error. We don't know what error you get, so we don't what problems you have.
Thank you,
Nope, Thank you Cievo,
It was rather late yesterday and I was drawning into my tests ...
So, the error message, translated to English is something like :
The expression under Click action set as event parameteris the orgine of the error. Authorization refused.
What this button does is
Set vl_WordDoc_Obj = CreateObject("Word.Application")
NomDoc = "basedoc.dot"
vl_WordDoc_Obj.Documents.Add Template:="\\ServerName\Directory\" + NomDoc, NewTemplate:=False
vl_WordDoc_Obj.Selection.GoTo , Name:="idfield"
vl_WordDoc_Obj.Selection.TypeText Text:=rs.Fields("clientid").Value
...
Basically, based on a request, I open a word document based on a template and fill it up with data.
Hope this is more comprehensive.
Well, I have re packaged the all Office 2003 suite and tried it again .. successfully.
I guess it required some stuff that is only installed with the installation of the other applications from the suite.
And just to confirm, it runs the Word installed localy even if Word was part of the package.
Cheers
Self-solving solution 🙂
Have a nice day,