Search results

I realize that subreports will not print when data is not present. However, I have a main report with about 6 subreports below it. I'm getting several BLANK pages when the subreports have no data. How do I suppress this so that I do not get half a dozen BLANK pages??? Thanks!

Thanks! So how do I fix this? I pretty much am done with the tables, forms, etc. Was working on the reports and noticed that the FK was not printing which lead me back to the tables and the FK not in the child tables. Thanks!!

Is there a way to force access, or perhaps I am doing somethign wrong, to save the primary key into a related tables foreign key? For example I have one primary table with a primary key (UserID) set to autonumber. I have a couple of other tables related to this primary table and they use UserID...

I have one form that basically prints out every field for the multiple tables that I have. I would like to reuse this form and would like three features. A print button to dump the entire tables content, which I believe the wizard would do for me. I would like two other print features that will...

Thanks! That worked. Now for some reason the sub reports always default to the right side where the slide bar has to be moved from right to left. How do I get rid of the slide bar so that nothing gets cut off? I formatted it so that all the data is within the page margins but for some reason the...

Ok, I think I got it. I embedded sub reports into the main one and the data is showing. HOWEVER, I cannot see the label fields in the report. The only thing displaying is the data....

Ok, I have about 12 tables. I made a form, that has the main table as the container of the other sub forms. All of the tables are related to each other via the same foreign/primary key. For some reason I cannot create one single report that shows all of the data from all of the tables. I add the...