Need Equal Length Columns - HELP !!! (1 Viewer)

dVESTERN · Feb 24, 2019

I have created a report that has 50+/- entries in the DETAIL Section and some count statistics in the Report Footer. It is a 3 column report. My issue is when I use the "across-then-down" method of distribution the report looks fine.
(see Capture1)

When I use the "down-then-across" distribution method I only get 1.5 columns of data and the Report Footer gets pushed off the page.
(see Capture2)

What I would like is to use the "down-then-across" distribution method and have the 3 columns equal length.

Any Suggestions?

Thanks in advance,
Dave

JHB · Feb 25, 2019

The only way I can see you maybe will be able to get it, is to manipulate the page length by code.

isladogs · Feb 25, 2019

Agree with JHB.
The default behaviour is to fill a column then fill the next etc.
So I think you'll need to use code to:
1. Calculate the number of records
2. Divide that by 3 and round up to next integer to get rows required in each column
3. Adjust the height of the detail section to match that needed for the rows required.

Have fun

dVESTERN · Feb 25, 2019

Hi JHB & Isladogs, and thank you for your replies. I sort of came to the same conclusion yesterday but was unsuccessful in getting the desired result.

Attempted to use Me.Detail.Height = 5000. Seems to adjust the individual record height instead of the Detail Section height.

Any suggestions?

JHB · Feb 25, 2019

Could you post the database included some data and the report (+ name of the report), because I don't really want to input/enter some fake data + make a report when you already have it. Remember to "Compact & Repair" it and then zip it then you haven't post 10 post yet!

dVESTERN · Feb 25, 2019

Again, thanks for your help JHB.

Have attached a ZIP'd copy of the database.
Auto-opens to a Main Menu Form

Select "Daily Staff Update" button
Set date for 2/1/2019
The report that will be launched is: MDOut subreportA-NU

Thanks in advance

JHB · Feb 25, 2019

I'll have a closer look at it tomorrow.

dVESTERN · Feb 25, 2019

Thank you,
Dave

JHB · Feb 27, 2019

Here is one idea how you can do it, I'm sure you're able to finish it.

dVESTERN · Feb 27, 2019

JHB,

I'd say good morning but I believe it's afternoon where you are. Your solution looks great. It is going to take a while for me to digest and fully understand how you did it but I'm looking forward to every minute of it.

From a BRIEF review I can see you built a Table, assigning a category 1, 2, or 3 to the data elements. Seemingly, followed by 3 sub-reports, one for each category.

Beautifully elegant solution!

I've been working on this database on and off for a few years. Normally, I have been able to figure out how to accomplish everything on my own and with the help of previously posted solutions.

In this instance, I was at a loss. Very glad I chose this forum to post a question. I am so grateful for your help!

Again, thanks!

Dave S.

JHB · Feb 27, 2019

You're welcome, good luck with your project, (your long-term database, your baby!

).

dVESTERN · Mar 26, 2019

JHB,

Ran into a problem. Your code runs fine on Windows 10. The rend user runs Windows 7. On their and my Windows 7 machines I get an error 3197 (multiple users trying to updated record) at the "rat.Edit" command.

Any thoughts"

dVESTERN · Mar 26, 2019

Make that the "rst.Edit" command.

JHB · Mar 27, 2019

dVESTERN said:
JHB,

Ran into a problem. Your code runs fine on Windows 10. The rend user runs Windows 7. On their and my Windows 7 machines I get an error 3197 (multiple users trying to updated record) at the "rat.Edit" command.

Any thoughts"

Do they all have a copy of the database or are they using the same database.

isladogs · Mar 27, 2019

Have you checked for missing references on the Windows 7 machines

dVESTERN · Mar 27, 2019

On my Windows 10 machine is where I do development work. The database works perfectly there. I emailed a copy to the end user running Windows 7, single machine, single user. There is where the error first became apparent.

Moved the database to my Windows 7 machine via USB drive. Getting the same error on my Windows 7 box.

dVESTERN · Mar 27, 2019

In all cases, we are using copies of the same database. All single user and single machines.

isladogs · Mar 27, 2019

So have you checked for missing references?

dVESTERN · Mar 27, 2019

I'm not sure of what you mean by "Missing References".

I took a copy of the database from my Windows 10 machine and placed it on my Windows 7 machine via a USB drive.

isladogs · Mar 27, 2019

Click Visual Basic on the Database Tools menu.
The Visual Basic Editor will open. Click References on the Tools menu.
There will be at least 4 references ticked.
If any are marked MISSING, those will need fixing.
If so, take a screenshot and post it here.

Need Equal Length Columns - HELP !!! (1 Viewer)

Registered User.

Attachments

Have been here a while

MVP / VIP

Registered User.

Have been here a while

Registered User.

Attachments

Have been here a while

Registered User.

Have been here a while

Attachments

Registered User.

Have been here a while

Registered User.

Registered User.

Have been here a while

MVP / VIP

Registered User.

Registered User.

MVP / VIP

Registered User.

MVP / VIP

Similar threads

Users who are viewing this thread