I've created a database that uses a form filter as the basis for presenting forms and reporting of records. The filter fields as chosen on the form are saved as a query for appliction to the forms and reports. The fields chosen to act as filters (as well as the data chosen to act as the filter - e.g. a person's initials) needs to be reported on a report. There are about a dozen fields that can be used as the basis for the filter though normally only 1-2 will be used. I therefore need a way of reporting only the query fields that are active as filter criteria.
I hope that is clear and that someone can help!
see prevoius question and use that for your report. If a value is not used in the form then ill assume thats its let null then set the textbox in the report Visable=False... ie Iff([froms]![frmOpen]!Text1.Value=Null,rptText1.Visable=False,rptText1.Visable=True).
I see at least one EE question a week that pertains to using temporary tables in MS Access. But surprisingly, I was unable to find a single article devoted solely to this topic.
I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…