print active document from access vba

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

Hi.

Still couldn't solve my absolute path problem I posted earlier this morning.

Now I try to directly print out a word document from within access vba

this is the function I am calling
________________________

Public Function PrintBill()
Dim printedOK As Boolean

Set DC = GetObject(Word.ActiveDocument)

printedOK = DC.PrintOut(, , , , , , , 2) ' print 2 of the same
doc
PrintBill = printedOK
End Function
__________________________

I set the word application visible so I have to go to word and press the
print button manually.

Any help most welcome as I don't have a clou as to what the syntax might be

Thanks,
Gina
 
Still couldn't solve my absolute path problem I posted earlier this
morning.
Click to expand...

You can't use a relative path for linked tabledef links. You can get the
folder that the current db is in quite simply though:


strPath = Left(CurrentDB.Name, _
Len(CurrentDB.Name) - Len(Dir(CurrentDB.Name)) )

Sorry if you already knew that... :-)


Tim F
 
Hi Thim.

Thanks for your answer.

well ... I probably didn't express correctly what I am trying to do

will post a new one on the topic

Gina
 
Back
Top