Microsoft Office Document Image Writer

[David C]

I would like to use this printer driver to save a TIFF file of an Access
report I have in a 2003 application that I am using. However, I do not want
to be prompted for a file name but would rather just use a default and have
it save to a folder and name I supply. Is that possible in VBA code and if
so, how? Thanks.

David

 

[Stephen Lebans]

I've done this using the MODI ActiveX control on an Access form but not
directly via the MODI Printer Driver. A GoogleGRoups search should yield the
info to manipulate the driver directly(probably via the Registry)>

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[David C]

Stephen,

I'm lost on this. I found the MODI library reference and added it to my
Access 2003 code and used the following but it gives me an "unspecified
error" on the line of the PrintOut method. Can you help? Below is my code
and it follows the print preview of the report so I assumed it would use the
active report.

DoCmd.OpenReport "rptCustomerBilling", acViewPreview, , strWhere

Dim miDoc As MODI.Document
Set miDoc = New MODI.Document
miDoc.Create
miDoc.PrintOut 1, -1, 1, "Microsoft Office Document Image Writer",
"c:\lifetime\finalbill.tif"
Set miDoc = Nothing

David

 

[Stephen Lebans]

David, as I mentioned in my initial reply, you would have to manipulate the
MODI Printer Driver, probably via the Registry , if it can be done. You
would also have to set the Access Printer object to that of the MODI driver
prior to printing the report.

To accomplish this programmatically via the MODI class in VBA, you would
have to first print the Report to disk via the MODI Printer driver. Then
LOAD this file into an instance of the MODI.Document class, and finally
output the report to TIFF format.

A GoogleGroups search of:
modi lebans

This will yield several relevant threads with pointer to two Web sites with
complete docs and sample code to help you understand and implement the MODI
object from VBA.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[David C]

Thank you.

David, as I mentioned in my initial reply, you would have to manipulate
the MODI Printer Driver, probably via the Registry , if it can be done.
You would also have to set the Access Printer object to that of the MODI
driver prior to printing the report.

To accomplish this programmatically via the MODI class in VBA, you would
have to first print the Report to disk via the MODI Printer driver. Then
LOAD this file into an instance of the MODI.Document class, and finally
output the report to TIFF format.

A GoogleGroups search of:
modi lebans

This will yield several relevant threads with pointer to two Web sites
with complete docs and sample code to help you understand and implement
the MODI object from VBA.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.