My database is complete and is about to be distributed to 31 locations (public schools). I would like to customize the reports with the school name, without having to create 31 versions of the database. Most of the "users" have little or no experience with Access, so it must be a simple solution from the user's perspective. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Customize Reports
- Thread starter gjacks
- Start date
You can create a feild in a query that prompts the user to put in the name of the location when they run the report. In the bottom part of the query grid for query that is the record source for the reports just type SchoolName:[Enter School Name]. This will prompt the user with a parameter box. Then in the Report Header Type (for instance) ="Report For: " & [SchoolName].
It might even be easier to have a drop down list on the form where they select their School Name and then have the report read the name off of the combobox. (I am not sure how to do that exactly)
Dawn
It might even be easier to have a drop down list on the form where they select their School Name and then have the report read the name off of the combobox. (I am not sure how to do that exactly)
Dawn
- Status
Similar threads
- Locked
- Question
