Layout Format

[Mrdude1020]

So Im building a Messages Database for my general manager, and as of now I have two tables, one for phone messages and missed calls, the other is for just general notes. This is mainly to cut down the amount of paper and notes she gets stuck to her door. Im trying to see if there is a way to get both on one table with the colum headings and such still on the table. That way she doesnt have to print off two sheets when it could just be one. Please help me!

[Z1nkstar]

Well I would make a report, reports are mainly used for printing out information do a report and add the fields in but be mindful of the paper size your using

[ItsMe]

Might want to look into building and saving Named Queries if you have not done so yet.

[Mrdude1020]

So I made one report and included a sub report but for some reason when i try to print them together only the one report prints. How can i make it to where they both print on one page?

[Z1nkstar]

On the button where you are printing I believe all you have to do is add another event and tell it to print the other report as well.

[Mrdude1020]

I dont have a button, I just have been clicking print preview to see it all together after i designed the layout in design view but it shows up in every view except for print preivew. If i need to make a button what expresssion do i use?

[June7]

These tables do not have relationship?

Which section of main report did you put the subreport in?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Z1nkstar]

when you open both reports I sugest putting a button on each that will allow each of them to be printed in on click for the button Event should be PrintObject

[Mrdude1020]

Lorry's Messages Database.zip

This is the zipped folder for the database here. Any help would be greatly appreciated!

[Z1nkstar]

The zip file contains a locked database there is nothing we can do with that>

[June7]

Right, that's the temporary locking file (.laccdb) created by Access. Need the .accdb file.

[Mrdude1020]

hmm let me know if this attachment works:
Lorry's Messages Database2.zip

[June7]

The subform container control Master/Child Links properties are set for linking on Date fields. Remove them and all notes will display. If you want the linking then the subreport needs to be in the main report detail section.

BTW, Date is a reserved word and should avoid reserved words as field names.

[ssanfu]

Just for fun, I played around with your dB. Maybe it will help or give you some ideas..

[Mrdude1020]

Thank you so much ssanfu! This helped me out tremendously! I really appreciate your help!