[AccessD] Fwd: Creating Word Doc in Access

Stuart McLachlan stuart at lexacorp.com.pg
Tue May 31 23:00:24 CDT 2022


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.

On 31 May 2022 at 19:41, Rocky Smolin wrote:

> Dear list:
> 
> Below is an email from a guy I help out fro time to time.  my ideas
> why he's aving this problem?
> 
> TIA
> 
> Rocky
> 
> 
> ---------- Forwarded message ---------
> From: James Charlton <James at charltonweeks.com>
> Date: Tue, May 31, 2022 at 4:07 PM
> Subject: Creating Word Doc in Access
> To: Rocky Smolin <rockysmolin2 at gmail.com>
> 
> 
> Good afternoon
> 
> 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...
> 
> 
> 
> ?
> 
> 
> 
> I´ll be in in the morning and call... when are you available?
> 
> 
> 
> 
> 
> James Charlton
> 
> Charlton Weeks LLP
> 
> 1031 W Ave M14, Suite A
> 
> Palmdale, CA 93551
> 
> 661-265-0969
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com




More information about the AccessD mailing list