O
ossie1971
Hi Guys
I am reasonably new to Access/Report design so please bear with me.
My bg is in asp/.net web programming so this is really the first time I have
looked at the reports feature of access; Here's my scenario
My client currently as around 15 Word docs that he has to fill in for each
of his clients, most of these only require the name / address adding at
various places throughout the document. At present they fill each form in
manually. My Idea was to create a clients table, Convert the word docs to
Access Reports, Design a form with a "Print" Button on it that runs a macro
to print of the 15 seperate reports, automatically populating the client
info as it goes via a query.
The problem
On some of the documents the static text can run to 5 or 6 pages and access
tells me I do not have enough room to do this. I did llok at reversing the
process and querying the data into MS Word but this basically screwed up
everything on the page!
Any suggestions on the best way to achieve this, I am trying to cut down on
the amount of document storage that is needed so do not really want to go
into the realms of exporting to RTF files etc, Like I say 15 docs per client
s
Many thanks
ossie
I am reasonably new to Access/Report design so please bear with me.
My bg is in asp/.net web programming so this is really the first time I have
looked at the reports feature of access; Here's my scenario
My client currently as around 15 Word docs that he has to fill in for each
of his clients, most of these only require the name / address adding at
various places throughout the document. At present they fill each form in
manually. My Idea was to create a clients table, Convert the word docs to
Access Reports, Design a form with a "Print" Button on it that runs a macro
to print of the 15 seperate reports, automatically populating the client
info as it goes via a query.
The problem
On some of the documents the static text can run to 5 or 6 pages and access
tells me I do not have enough room to do this. I did llok at reversing the
process and querying the data into MS Word but this basically screwed up
everything on the page!
Any suggestions on the best way to achieve this, I am trying to cut down on
the amount of document storage that is needed so do not really want to go
into the realms of exporting to RTF files etc, Like I say 15 docs per client
s
Many thanks
ossie