Access for Masochists

As far as I can tell Microsoft access is designed to be used by masochists. For example, suppose you want to make a 6-page report. Should be fairly easy, right? Just make a report stick 5 page breaks in and you’re done, surely? No. There’s a seemingly arbitrary height limit of 22″ on reports. You’ll have to make a few individual reports, lets say one for each page, and then insert them as subreports into a main report. And then set the “can grow” attribute to true so that they fill the available space. Or you could write a macro that combines them.

I guess it must make sense to someone, somewhere. Maybe it’s a technical limit from earlier versions that’s been carried over to the new versions. Maybe Microsoft are a group of sadists. Who knows?

Advertisements

About Mr Chimp

I make music, draw pictures, browse the internet, programme, and make sweet, sweet cups of tea until the early hours.
This entry was posted in Uncategorized and tagged , , . Bookmark the permalink.

3 Responses to Access for Masochists

  1. Dan says:

    Out of interest what kind of reporting program are you using? Is it the inbuilt one in access using VB Script? Crystal report? or something else.

  2. Mr Chimp says:

    I’m using the inbuilt one.

    *googles crystal report*

  3. Mr Chimp says:

    After trying to update access (due to an unrelated issue) i’ve come to the conclusion that Microsoft are a bunch of sadists after all.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s