Can a report be put in a form?
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.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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"
Note: The form closed once it display the report.
I cannot figure out how to put the Report or a way to launch it on my Form.
I need to pass a Date to the Report.
I have a Date Picker and Launch button on my Form.
I just can't find the control for a Report
I can get the report to open when the form field reads a single criteria like "Cross Country". My problem comes when I try to get the report to open when the field says Varsity Soccer or JV Soccer.
If I put *soccer* directly in the query criteria the report opens. If I put *soccer* in the form field and then get the query to read the criteria from the form, the report will not open.
I have also tried "Varsity soccer or JV soccer" in the field and it still does not work.
What other wording can I use to get all the Varsity soccer and JV soccer names to open in the report? Or what other approach should I use?
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?
Just for reference, here's the expression in the Percent11 text box:
I assume I will have to create a form and put the drop downs in the form header and make the report a subreport to that form. Past that I'm not sure how to make it so when I make the selection it automatically filters the report.
My fields I am trying to filter by are Invoice, House, Brand and then on a yes/no value for a field called Billed Back. I can provide more details if needed.
See names below:
Input Form: CC Form Entry
Unique Field: CC Number
Report: Customer Complaint Form
when I apply the filter to the form, the filter applies correctly. but as soon as I try to put those results into a report I get boxes asking me to enter in asset_typeID.
problem is that when I filter with combo boxes, it returns the name of the asset_type and not the asset_TypeID.
ex. for laptops the ID = 4