Recent content by GWally

You were a great help with a previous report question. I now have another question. New thread is in report section titled "Report Header Question". Any help here would be appreciated. Thanx GWALLY

I am trying to force to new page if all the data from 2 headers will not print on same page. Any effort here is appreciated. GWally

Excellent. Thank you Beetle. I was literally putting the Cancel phrase in the "OnFormat" box instead of programming it in the private subroutine. Again thank you for your time, patients and the lesson. Nicely done. Greg

I do appreciate the help. And the tolerance of those of us that are learning. Greg

Was not aware that OnFormat only fired on print. I still couldn't get it to work. Mini db included with this post. Your effort is appreciated here. Thank You Greg

Sorry .... Any way to make the condition based on Member.ID <>BoatInfo.MemberID instead of a Null value?

Tried Cancel=IsNull([BoatMake]) ... no affect. This makes sense because there are no records that have Null values in BoatInfo table. I also tried to add an entry with Null values in BoatMake and deleted data from from BoatMake in 5th record as well. Any way to make the condition based on...

I do intend to include a page header and footer after report layout issue is resolved. Would it be a good idea to include that before report layout issue is addressed? Greg

jdraw, Please keep in mind I am an intermediate user at best. Hence the questions. Will the "Where" clause mentioned (1 --WHERE BoatID.MemberID IS NOT NULL) print include all parent records and include child records as shown in the example listed in initial thread entry? Seems like that...

Report layout as requested.

Appling suggest resulted in the following. Report output, table and table relationship is shown Below: Have other suggestions? Greg

Name is Greg. I am an intermediate Access user. What I am trying to do: I have 2 tables, Parent and Child. Tables have a relation ship of one -many (Some Parent records have many Child records). I want to print all Parent records with Child records below the associated Parent. Looking to...

I am an intermediate Access user with questions on forms, queries and reports. I am looking forward to utilizing this forum to assist in the development of my databases. Greg