Report Formatting (1 Viewer)

[spacepro]

Hi All,

It's been a while. I have created a system where I want to email a report to a third party in a particular format, basically in Snapshot format.
The problem I have is that they don't have access to the format and I am trying for them for there IT to get it installed.

Is there a way that I could transfer the report to word and keep the formatting of the report through automation/vba exactly how it appears in access.

I have already done a search but to no avail.

I have also played with the idea of PDF, but this requires Adobe writer to be installed which they do not have.

Any ideas on how I could get round this?

Many Thanks

Andy

 

[Hayley Baxter]

Hi Andy

I was able to use the sample I found in this thread to keep formatting in an access report and take it to word.

http://www.access-programmers.co.uk/forums/showthread.php?t=55312&highlight=access+report+word

Hope this helps
Hay

 

[spacepro]

Thanks Hayley,

I have had a quick look and it won't work, because I am using a parameter query as the data source of the report. I will keep trying though.

I am also working on doing it through PDF...PrimoPDF.

Thanks

Andy

 

[spacepro]

Silly Me!. I forgot to have the form open that the query relates to.

Seems to work, just need to change it now to automate it from a button press. Thanks Hayley.


This problem seems to be quite common. When I have completed it I will post a sample db in the sample db section for future reference.

Many Thanks Hay

Andy

 

[Hayley Baxter]

No Probs, glad you got it working.

 

[usiddiqi]

i can not find that particular section mentioned in the other thread, can anybody of u help me finding that one, or post the direct link...

Regards,
Umer

 

[spacepro]

Umer,

Visit the following link and look at the one titled Report Utilities.

http://www.lebans.com/Report.htm

This is the sample I downloaded at the time.

Cheers
Andy