 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006generating a file per record in reporting
Hi I'd like to generate a report where output is exported to a word- or pdf-file. Further the report should generate files for each record. Is there an easy way to do this? Thanks in advance! Benno You can create a standard report that show every record you want, then in the Detail_Format event (event that occured every time a record is added to the report) write your code to export data to an external file. > Hi > [quoted text clipped - 5 lines] > Thanks in advance! > Benno To start with: Thanks for your hints Unfortunately it doesn't help me a lot because I am not a programmer ... Aren't there any solutions where no programming is needed. On the other hand I just need it for one time. Benno Unfortunatly, I am not aware of any way to do it without VBA code. Sorry! I hope for you freakazeud will know it. > To start with: Thanks for your hints > [quoted text clipped - 4 lines] > > Benno Nope, there is no real simple method. Unless you are doing it manually by making the report show one record at a time and then exporting it to whatever you want, but that would take forever depending on how much data you have. HTH Good luck  SignatureOliver Admin Specialist & Computer Science Major @ UMD - Go Terps - :) http://www.oli-s.de > To start with: Thanks for your hints > [quoted text clipped - 4 lines] > > Benno Thanks a lot for your inputs. Then we will probably export it manually - t would be "just" 150 reports .... :-( Benno > Nope, > there is no real simple method. [quoted text clipped - 12 lines] > > > > Benno Hi, not sure if it will be easy, but there are ways to do so. The pdf method might be a little more complicated since access doesn't support the pdf format yet and you would need to integrate a custom pdf procedure. But to test it you could start with outputting to rtf (rich text format, word). Have a look at this discussion to get started: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=85&Number=1028679&Foru m=&Words=output%20%2Beach%20%2Brecord%20%2Bas%20%2Bnew%20%2Bfile%20%2Breport&Sea rchpage=0&Limit=25&Main=1025587&Search=true&where=bodysub&Name=&daterange=1&newe rval=&newertype=m&olderval=&oldertype=#Post1028679&bodyprev= and http://www.utteraccess.com/forums/showflat.php?Cat=&Board=89&Number=744445&Forum =,,&Words=output%20%2Beach%20%2Brecord%20%2Bas%20%2Bnew%20%2Bfile%20%2Breport&Se archpage=1&Limit=25&Main=740391&Search=true&where=bodysub&Name=&daterange=1&newe rval=&newertype=m&olderval=&oldertype=#Post744445&bodyprev= ... HTH Good luck SignatureOliver Admin Specialist & Computer Science Major @ UMD - Go Terps - :) > Hi > [quoted text clipped - 5 lines] > Thanks in advance! > Benno |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.