[AccessD] Locked Doc

[Rocky Smolin]

He went back to the previous method that was working and you'll never guess
what happened (of course you will) - it worked!  I didn't want to embarrass
him by asking why the code was changed in the first place.

r

On Thu, Jun 2, 2022 at 1:51 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> He said "We were using wd.FileSaveAs  Path/Doc name" so  I asked him if
> that was working. He said yes.  So I asked him to revert to that and see
> what happens (this is too easy). He said he'd try and get back to me.
>
> But I think your idea of VBA still having a lock on it could be the
> reason. And Susan's suggestion of setting wd = nothing might release that
> lock.
>
> We'll see.
>
> r
>
> On Thu, Jun 2, 2022 at 1:47 PM Stuart McLachlan <stuart at lexacorp.com.pg>
> wrote:
>
>> You asked the same thing on this list two days ago as "Fwd: Creating Word
>> Doc in
>>     Access"
>>
>> I asked a couple of follow up questions but got no response:
>>
>> <quote>.What does he mean by "try to bring it up"?  Is he activating in
>> the VBA function or
>> is he
>> going to the location and trying to open it in Word?
>>
>> Is he closing it in the VBA functionbefore trying to open it?
>>
>> Sounds like the VBA function still has a lock on it.
>> </quote>
>>
>>
>> On 2 Jun 2022 at 9:20, Rocky Smolin wrote:
>>
>> > Dear List:
>> >
>> > I got the following from a client. I don't see anything wrong with the
>> > save statement but I'm not that familiar with Word automation.  Any
>> > ideas what's going on?
>> >
>> > MTIA
>> >
>> > Rocky
>> >
>> > The problem I am having is when Access creates a letter, it then saves
>> > it to a predetermined location and THEN when I try to bring it up,
>> > word says it is locked by the person that created it... WTF
>> >
>> >
>> >
>> > We were using we.FileSaveAs  Path/Doc name
>> >
>> > Brad changed it to
>> >
>> >      wd.ActiveDocument.SaveAs2 Filename:=FDN, FileFormat:= _
>> >
>> >         wdFormatXMLDocument, LockComments:=False, PASSWORD:="",
>> > AddToRecentFiles _
>> >
>> >         :=True, WritePassword:="", ReadOnlyRecommended:=False,
>> > EmbedTrueTypeFonts _
>> >
>> >         :=False, SaveNativePictureFormat:=False, SaveFormsData:=False,
>> >         _
>> >
>> >         SaveAsAOCELetter:=False, CompatibilityMode:=15
>> >
>> >
>> >
>> > Now you can only open the document as a read only...
>> >
>> >
>> >
>> > ?
>> > --
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > https://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> https://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>