Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ActiveDocument.PrintOut not working

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
When trying to use the ActiveDocument.PrintOut command in
an Access event procedure when a command button is clicked
I am getting an "13 Type Mismatch". I am trying to pass variables to the PrintOut command for From and To pages.
Both are defined as Long variables. Syntax being used
is:
objWord.ActiveDocument.Printout Background:=False,
Append:=False, Range:="3", OutPutFileName:="",
From:=FromPg, To:=ToPg

The Word document opens fine.
 
I've answered my own question on this one. The PrintOut
command requires a text string for the From and To pages
arguments. All I needed was to define 2 additional variables
and set these equal to the Integer variables set from my
Access form unbound text fields entered by the user.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top