Search

[nashr1928]

I am using access 2003 and want to know if its possible to search thru reports to find a particular report?

[rpeare]

YOu mean to look for a particular report name in a list of report names? Or to look for the contents of a report?

[nashr1928]

Currently on everything but reports I use search by selection and that works fine. Example if I want to look at a certain record by year I just highlight the year and search by selection. You cant do that with reports. Currently I just scroll thru the reports until I find the one I want, but as my database grows, It will be a hassle because of the number of them. Am I making any sense?

[rpeare]

I still don't understand why why would the number of reports you generate grow so drastically? Are you making reports that have static criteria as opposed to a user defined criteria? For instance if you want to look at calendar year 2005 are you physically putting

Between 1/1/2005 and 12/31/2005

in your query criteria or are you using something like

between [enter the start date] and [enter the end date]?

There is a way to show report names in list box but I don't think I've ever had a reason to create so many reports that they get lost in the shuffle.

[nashr1928]

So as Im not being clear enough. I will attach 2 files. One is the actuall report and the other is the form that is where the data is inputted. I have a form that I input data that goes to a table and the report is generated. As I create a new record on the form then a new report is generated. I now have around 50 reports. If I want to find a particular report, I have to scroll thru them until I find the one I need to email to the customer. I would like to try to find a way to find a certain report by year and or customer name instead of scrolling thru all of them.

[rpeare]

Create a query that is based on the current record displayed on your form, in the criteria of the ID (your unique key field) put in

[forms]![data entry form name]![unique key field]

where you would subtitute in your form name and field name

This should give you a query with one record on it.

Then use that as the data source for your report instead of the entire data set.