how to save an access report to file ??

[pdtit]

Hello,

Is there something possible to store an access report as a file like pdf, tiff,...
(e.g. when an invoice report is print out, it should be saved as a read-only file as well)

Regards,

pdtit

 

[ChrisBelzona]

Hi

You can export a report to snapshot format. this will then be readonly but users will require either access or the snapshot viewer available from microsoft as a download 9mb or on the access installation disk (i think).

It's pretty good.

Cheers

Chris Russell

 

[pdtit]

Chris,

Thanks for your feedback. However, I'm sorry to say, but it's not the thing I was looking for.

What I wanted to do is to "save" an invoice report in read-only format and print the same file. When the invoice is printed and than saved in a "non-changeable" format, this makes sure that the invoice which is printed, can not be changed in any way anymore. I was more thinking of a tiff file, but can't find anywhere on how to save this. The rtf-format can be changed in MS Word, so it's not fine in this situation.

Do you know if i can export maybe only the data in a text-file ? Or is there maybe a tool with which you can read printer-files ? In that case, I could save the file in a print-file format and read it from another application.

Any suggestions maybe ?

PdtIt

 

[ChrisBelzona]

Pdtit

Is this your situation.

You have a invoice which is printed to a hard copy (is the invoice run single or multiple invoices?) You then require a method of saving this invoice in a file format (Is this for reference purpose only?).

Is that your situation, if not can you give me a little more information?

Cheers

Chris Russell

 

[Kjonnnn]

All you have to do is click on FILE>.. EXPORT... and choose the format u wish to save it as.

 

[pdtit]

Chris,

This is exactly my situation.

You know, when an invoice is made, it shouldn't be edited afterwards in any way.

So, if you know a way out...

PdtIt

 

[nadms]

Hi pdtit,

I agree with what ChrisBelzona suggested. I require the same thing.

User can print a report but they cannot edit a file that is generated through Print to File. This file is for read only.

I use SnapShot Viewer and I think it is wonderful tool to view a report. I put the following code;
DoCmd.OutputTo acOutputReport, "My Report", acFormatSNP, "C:\Reports\Report1.snp", False

May be you could try it out.

 

[schum1]

Hello pdtit,

I use Adobe Acrobat 5 (not the reader) to create pdf files from Access reports. You need (of course) to purchase the program. It is quite easy to create the pdf. When the report is open, select File, Print and under the printer name you will see an option - Adobe PDFWriter. After I created the pdf file, I also apply Adobe's 128-bit security to further ensure that users cannot copy or change the data.

I hope this helps.
Marietjie

 

[ChrisBelzona]

pdtit

The snapshotviwer option would work fine in your situation, I do something similar already for printing and saving a copy of the invoice I have two commands on the print button.
one to print a hard copy and the other with the line nadms suggested.

The other option is a bulk run with you just loop through each record printing a hard copy and then nadms code to create the file. The only thing to remember is that you create a different filename for each invoice (I use the invoice number for obvious reasons).

Hope all these suggestions help you.

Chris