Thread: [Solved] Creating a Word Document in vba from an Access Function
View Single Post
 
Old 05-13-2020, 01:43 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
Which simply means you need to specify where the table gets added instead of using the Selection object again

Code:
oWordDoc.Tables.Add Range:=oWordDoc.Paragraphs.Last.Range, NumRows:=iRecCount + 1, NumColumns:=iFldCount, DefaultTableBehavior:=wdWord9TableBehavior, AutoFitBehavior:=wdAutoFitFixed
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote