Maximum number of objects in report

[Zooropa]

Hi there,
I have a report created in Access which is an assessment form - a questionaire.

It is 4 pages long, and has lots of controls on it.
Over 1000, I think.
The problem is that Access only allows 745 (I squeezed the extra in by copying and pasting existing ones - it gives an error, but still creates the object).

The report is handy in that users can populate some basic information straight from a table just by opening it, then printing.

We used to use Word and mail merge from the table, but Word is pretty poor and messy for creating forms, and for mail merging.

It's got to the point now where I can't export/import/copy-paste the whole report into different databases. It doesn't even give an error. Simply nothing happens.

Is there any way around this issue without having to resign myself in going back to Word?

I've tried screengrabbing some of the questions and replacing the dozen or so objects with the one graphic object, but there is an obvious drop in quality when printed.

 

[ColinEssex]

Sounds to me like you need to re-think the way you've designed the tables.

Are the questionaire questions multiple choice for example? How have you set this up if they are?

Col

 

[Zooropa]

Sounds to me like you need to re-think the way you've designed the tables.

Are the questionaire questions multiple choice for example? How have you set this up if they are?

Col

The questions come in groups like
"Where Living [ ] (Please enter one number from the list)"
1. private Residence
2. Long stay NHS Ward
3. Supported accommodation

etc

Unfortunately, that's not really up for discussion, it's always been that way and I can't see the powers that be moving on it.

The report is printed off, and filled out by clinicians by hand.
We get the form back, and key it into another system.

We have the Access database to query the main system, populate the forms, and then produce reports from the assessments once they have been keyed into the main system.

 

[richary]

How about breaking up the report into multiple reports eg Report1 -> Page1-10, Report2 11-20 etc.
You could write a bit of VBA to print out each report sequentially, n times if you needed to.

 

[Zooropa]

How about breaking up the report into multiple reports eg Report1 -> Page1-10, Report2 11-20 etc.
You could write a bit of VBA to print out each report sequentially, n times if you needed to.

The report is only 4 pages, but yeah, I see where you are coming from.
Split the thing into 2, Report 1 being pages 1 and 2, Report 2 being pages 3 and 4.
That could work, although I can see myself getting tangled up in the VBA.

It'd have to say:
Print record 1, of reports 1, and 2
Print record 2, of reports 1, and 2
etc etc

I'm also toying with the idea of going back to Word, and creating a little menu in Access "Populate Forms", and from there it has a few options which go away, open up the Word document, populate it to a new document, and print.

Both seem feasible.

Some food for though, on a Tuesday afternoon.

Cheers.