Can a report be put in a form?

Views: 22

I have two tables, Student Information and Student Attendance. I have a Student Information form and also a Student Attendance form. The Student Attendance form is used to input daily attendance and the apend it to the Student Attendance Table.

My Student Information form is used for inputing basic student information and then it's apended to the Student Information table.

I'd like to make each student's attendance viewable on the Student Information Form. If so, could you explain how this is done.

I've also read something about subforms. This is my first time working with Access 2007.

Similar posts...

I have a form that open a report once I enter the parameter value for the query. Now I want include the parameter value into the report; but when I insert a textbox with=Report![Report_name]![Field_Name] the report start a loop, and give me an error.

How I can put the parameter value directly from the form, without dealing with the message box report asking me the parameter value again?

The result should display: "Old account with more than [Parameter_value(from the form, not the query)] days"

I created a form that basically is a launch point to a report. The form has a textbox for notes and a button to print the report. I have a label in the form which is a few lines of text, can I have the label show in the report? I put a text box in my report and the control source references the label in the form but when I print, nothing is displayed in the textbox in thereport.

I have a small problem amd help will be greatly appreciated . I have form frmInqiureDate and two text boxes on it txtBeggining and txtEnd. Also on the form command button which execute the code to print the report rptBrowardGarn with dates typed on form in these text boxes .Everything is working well, but resently my boss asked me to put dates on the report as well .I created two text boxes txtDateBeg and txtDateEnd on report rptBrowardGarn and put like this in control of the text boxes "=frmInqiureDate!txtBeggining" and "=frmInqiureDate!txtBeggining" , but the value of dates off the form is not showing up on report.It shows "error". What Am I doing wrong here?
Thnak you in advance for help.

I have a report that is based on a crosstab query. The crosstab query has a field called [Total by Form], which totals all occurrences of a form. On the report, I use the [Total by Form]with a field on a subreport to create a percentage expression, which I put in a text box called FormPercent.

I've now been given the task of giving the user the option on the form that's used to launch the report of filtering out all forms (I.e. rows on the report) that are less than 10%.

I've got the form setup to call the report and I pass the report an OpenArgs that tells the report whether or not to set the FilterOn property to 'Yes' or 'No'. Then, I was going to put myfilter expression in the Filter property of the report so that it would trigger when the report was run and the user indicated that they wanted to view the exceptions (those forms/rows that are equal to or greater than 10%).

I'm having trouble with the filter expression though. Can I create a filter expression for an expression that is in the report or can I only create filter expressions for fields that are in the underlying query?

I have a report based on a query that gets its criteria from a form. I want to put a dropdown or checkbox on the form that will tell the report to sort either by room number or last name,whichever the user selects on the form.

And which Access must load each time it opens the form/report which could slow it down is it easier/smoother to put the codeinto a general module that Access will load at startup and keep loaded and call the procs from the form/report module reducing the amount of code in these modules and speeding up the openingof the form/report

I have built a form-based search. On the form, users specify effective dates. Two buttons, "Report" and "Refresh", which refreshes the form only.

What's bothering users is that.every time they put in a new date and generate report, they have to hit the "Refresh All" button at the top of the access ribbon in "Records" group to see the new result.

I thought that if you just hit "Report" on the form, the report itself will automatically refresh.but this is not happening.

could you please tell me how to get the information from why query into a chart in my report
I have opened my report in design view put the chart in using wizard from my query but I dont know how to put the real data to the chart . as it shows me the test sample