Access VBA change Query criteria using QueryDef.SQL Property

Posted on February 1, 2017 by Wyman W

This Access VBA tutorial explains how to change Query criteria in VBA using QueryDef.SQL Property. You may also want to read: Create Query using CreateQueryDef Access VBA - change Query criteria It is easy to change Query criteria in Query View, but sometimes your criteria may depend on a variable that is not a constant. In Access VBA, you can change the Query criteria using QueryDef.SQL Property. In fact, QueryDef.SQL does not really update just the update the criteria of the statement,...

Access Report Section Property

Posted on April 27, 2015 by Wyman W

This Access tutorial explains how to use Access Report Section Property to control Report Section such as Page Header, Footer. Access Report Section Property In Access Report VBA, you can directly access the Controls in the Report, it is also possible to access the Report Sections using Report Section Property, such as Page Header, Group Header, Page Footer, etc. This is especially useful to hide the whole Section. Syntax of Report Section Property Me.Section(Index) Index Constant D...