Hello. I am a new here and have found this resource to be vastly informative. Much thanks to everyone. With that said, I am struggling with the following issue:
Currently, the only way I know how to retrieve information from my database is by writing a query or using a filter. Writing a query is time consuming and not fit for outside users. Using filters may be right for me but the output is not in the format I want. Here is why:
The table that I am filtering is large, many subforms. I can filter by form very nicely to find particular records, but the entire record is displayed. I would like an output in tabular form only showing those elements that have been searched for in addition to whatever elements the user chooses to show. I would also like the user to have the ability to maintain the use of basic functions in their search. For instance, display companies only with employees greater than 100,000. Basically I want the ease of the filter to accomplish the task of a query (with a form output). It would be nice to automatically force the output of a filter into a form "template."
I have begun looking at data access pages as a possible solution. Will this provide me with the capabilities I am looking for? Perhaps the better question is, can anything provide the capabilities I am looking for? The ideal solution would be an easy information recovery tool that someone with no knowledge of Access can use.
Thank you for any assistance you can provide.
Currently, the only way I know how to retrieve information from my database is by writing a query or using a filter. Writing a query is time consuming and not fit for outside users. Using filters may be right for me but the output is not in the format I want. Here is why:
The table that I am filtering is large, many subforms. I can filter by form very nicely to find particular records, but the entire record is displayed. I would like an output in tabular form only showing those elements that have been searched for in addition to whatever elements the user chooses to show. I would also like the user to have the ability to maintain the use of basic functions in their search. For instance, display companies only with employees greater than 100,000. Basically I want the ease of the filter to accomplish the task of a query (with a form output). It would be nice to automatically force the output of a filter into a form "template."
I have begun looking at data access pages as a possible solution. Will this provide me with the capabilities I am looking for? Perhaps the better question is, can anything provide the capabilities I am looking for? The ideal solution would be an easy information recovery tool that someone with no knowledge of Access can use.
Thank you for any assistance you can provide.
