Dear all, How to change the criteria value in a query using macro or vba? regards
T Tang Aug 12, 2004 #1 Dear all, How to change the criteria value in a query using macro or vba? regards
S Steve Schapel Aug 13, 2004 #2 Tang, You can't really do this with a macro. You can do it in a VBA procedure by opening a QueryDef object and setting its SQL property of the desired string.
Tang, You can't really do this with a macro. You can do it in a VBA procedure by opening a QueryDef object and setting its SQL property of the desired string.
