generating a file per record in reporting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
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/s...=m&olderval=&oldertype=#Post1028679&bodyprev=
and
http://www.utteraccess.com/forums/s...e=m&olderval=&oldertype=#Post744445&bodyprev=
....
HTH
Good luck
 
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.
 
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
 
Thanks a lot for your inputs. Then we will probably export it manually - t
would be "just" 150 reports .... :-(

Benno
 
Back
Top