SubReport on Form

[JamesJoey]

Adapt it as you wish but I doubt you can get the layout any better than I did
If you like the end result, please click the Like button. Thanks

Been using the new Weekly Agenda for a few days now and I just
wanted to reiterate how happy I am with the results of your assistance.
Looks like it took a lot of time and effort for you to get this to work the way I would like.

Thanks again,
James

 

[Gasman]

That will likely be as the date control is still there?
Remember, all Colin did was make the colour the same, so it was pretty much invisible, not remove it?

 

[JamesJoey]

Seems like alot of code for just setting the forecolor so they are invisible.

 

[Gasman]

Seems like alot of code for just setting the forecolor so they are invisible.

That statement tells me you have no idea as to how it was done?

 

[JamesJoey]

Actually, no I don't.

 

[isladogs]

The subquery I used in post #19 was the most important part of the solution as it allowed grouping by date. It may be worth studying that in detail.
Once that was used, a mixture of conditional formatting and hiding certain controls was used to layout the subform approximately as you had in your original subreport

 

[Gasman]

I was only responding to the CF for setting the fore colour.

 

[harpygaggle]

I'll give this a try and hopefully this will work for me. Thanks for keeping us posted. Will give updates too!

 

[isladogs]

I was only responding to the CF for setting the fore colour.

Hi Paul
I was responding to the OP's comments in post #28

 

[Gasman]

Hi Paul
I was responding to the OP's comments in post #28

Hi Colin,
I realise that, but OP just commented on 'a lot of code for just setting the forecolor so they are invisible. ', when all it was, was a simple CF statement.
Admittedly a fair bit of work to get some sort of order to enable CF to be used. Neat though.
FWIW I tweaked your DB to have them in time order per day as well, so any new entries occupied the (what is to me) the correct position.?

You know, sometimes I wish I was still using Access for some serious purpose, just for the mental stimulant.

 

[isladogs]

Hi Colin,
I realise that, but OP just commented on 'a lot of code for just setting the forecolor so they are invisible. ', when all it was, was a simple CF statement.
Admittedly a fair bit of work to get some sort of order to enable CF to be used. Neat though.
FWIW I tweaked your DB to have them in time order per day as well, so any new entries occupied the (what is to me) the correct position.?

You know, sometimes I wish I was still using Access for some serious purpose, just for the mental stimulant.

Good idea to sort by time as well as date....

I do still enjoy the mental stimulus of finding solutions to problems e.g. using a subquery in this case.
The advantage to me is that I can then sometimes adapt solutions for use in my own applications

 

[JamesJoey]

Sounds good.
Haven't done much in Conditional Formatting.
But this all works the way I want.

 

[CedricBlown]

Conditional formatting works best for me in identifying financial errors in my report. It quickly highlight cells that contain values greater or lesser than a specified value.