Recent content by dlamarche

Hi Chris. When I read your post I didn't notice you mentioned "the event procedure must be public". Plus I was annoyed at all the post before that discourage the approach. So, I didn't click that you indeed gave the tip. So the post was answered. My post, then, makes it a bit clearer how to...

This post has been there for a long time but the exact answer hasn't been provided. To run an event procedure in a form from another form (which is rarely but occasionally useful) you must do two things: 1) Remove the Private keyword in front of the name of the Sub you want to call. If you...

Hi Stopher, Thanks for this sample. It would do the job for sure. Interesting that it resemble the approach I had in mind but I was working with the Page event (made sense to me). Using the Group Headers and Page Header events does the job. This seems to look like an old exercise I did years...

I know very well this property and this is not related at all to my question. Now allow me to ask my question again. It is a VBA question. I am trying to find out in code if the page being printed contains the Group Header. The details section for a Group can span over several page and I...

Hello, I am looking for a technique in VBA to find out if a page in a report do show the GroupHeading. The reason is that if the Details for a Group level overflows on the next page I need to do something on that second page. The same if there is enough details to print that Group on three...