Recent content by Flag

I am using Access 2017 and have built an DB using Navigation Forms, horizontal tabs and vertical tabs left. Main form is named 'Home' with default subform name of Navigation Subform. I can print a report straight to the default printer. I can show a print preview of a report in the Navigation...

What a champion you are. You were correct with your first guess. I was not intending to base the report on a form but gave it a go. Once again I put the request for user input in the form header along with an update form button and a print button. Both form and report were based on the same...

I get lost all the time! ;-) Let's see if I can explain more clearly. At the moment I have a side button that opens a form (AttendForm). I put the 2 txt boxes in the header of this form (StartDate and FinishDate). Next to these I have a button that On_Click updates the form. Works a dream...

This is what I had already used on a form to filter dates. Between [Forms]![Home]![NavigationSubForm]![StartDate] And [Forms]![Home]![NavigationSubForm]![FinishDate] It works well but I had to put the txt boxes in the header of the form with an update button to requery the form. Clunky but...

Thanks sneuberg. Sounds good. Will give it a try and let you know. Cheers Flag

Thanks Ranman256. That is the method that I have used for years - outside navigation forms and it works well. However, it doesn't work for me within navigation forms. I think the problem is in the path referencing and sneuberg has pointed me in the right direction. I hope - will try it. Thanks...

Hi all. Have developed a few systems the 'old fashioned way' using command buttons. Have ignored navigation forms for too long. They are turning out to be a challenge! I have a db with top controls and linked side controls. All works well . . . until I try to print a report that is in the...

Emigrated to Australia in early 70s. Still a bit of Pommie in me! Have used Access for many years and have developed a few systems. Still have a lot to learn and it is still a challenge. Flag