generating a file per record in reporting

B

Benno

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
 
Y

Yanick

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.
 
F

freakazeud

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
 
B

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
 
Y

Yanick

Unfortunatly, I am not aware of any way to do it without VBA code.

Sorry! I hope for you freakazeud will know it.
 
F

freakazeud

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
 
B

Benno

Thanks a lot for your inputs. Then we will probably export it manually - t
would be "just" 150 reports .... :-(

Benno
 
Top