Size of reports

[Yardyy]

Hi, I need to print of a report that needs to haev seven pages in it, i know that limit for the report size is about 55cm, 55cm, an what ever i try to do, will not. i can get about four pages onto the report but thats it..

The report is getting data from a query that when selected prompts the user for an ID, when inserted, all the details in that for that ID are displayed onto the report then printed of.. issue is that i have a lot of fields in that table and i cannot remove any.. there is only table in this database also.

is there anyway that i can do this... not sure what to do next !

Many Thanks
Yurov Ardyy

 

[dhookom]

This sound likes a normalization issue. However, you can add more sections to your report. Create a new lowest sorting and grouping level on the primary key (or expression) in your report's record source. Choose to display this level's group header and footer. Each of these new sections can be quite large.

This basically increases the detail section 3 times.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Yardyy]

got a workaround for it, which seems to be working fairly ok..

this is what i did...

created an update query that puts data into a new table, then created 7 reports that print data from the new table..

only issue, i get these dialogue boxes that come up saying

"you are about to run a make-table query that will modify data in your table"

there are some other yes no type messages as well.

is there any way that i can suppress this or stop them all together from coming up..

Many Thanks
Yurov Ardyy

 

[dhookom]

Why put data into a new table? Why create 7 reports (unless you need 7 separate reports)?

Your solution seems a bit unconventional.

You can use code to run your queries. Begin the code with

    DoCmd.SetWarnings False

Then end your code with

    DoCmd.SetWarnings True

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Yardyy]

where do i put that code, i tried to insert another step in the macro, as RunCode, but did not work..



Many Thanks
Yurov Ardyy

 

[dhookom]

What's a macro ;-)
I believe there is a SetWarnings action that you can select.

Again, imho, I can't see a reason for creating the tables and extra reports. It seems you are making a much more complex solution than should be required.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Yardyy]

Thanks dhookom, you really know your access..

that now works a treat

would you know how to convert this access database from an .mdb file to an .exe



Many Thanks
Yurov Ardyy

 

[dhookom]

There is no native method for converting an Access MDB to an EXE. You can run an MDB with a run-time install. There is some information at

http://www.granite.ab.ca/access/developereditionversions.htm.

There will be a free Access 2007 runtime.

There are companies that sell products that claim to create EXEs from mdbs. I don't have any experience with these lately.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Yardyy]

Thanks for your help, much appreciated.

I will take a look at the link above.

Its forums like these, and people like you that make the internet a place of knowledge.

Many Thanks
Yurov Ardyy