[AccessD] dynamic sql - changing intermediate query sql on the fly at top level query runtime

William Benson (VBACreations.Com) vbacreations at gmail.com
Fri Aug 5 10:32:18 CDT 2011


Hi Lambert, I read Allen Browne's article
(http://allenbrowne.com/ser-67.html#ColHead). I also did quite a bit of
experimenting. No luck. In order to set that property effectively, you need
to be able to predict what values the data might hold in the field or
expression which it depends upon. Furthermore, Access will not change the
columns in queries downstream of that one. VBA is the only solution to this.




More information about the AccessD mailing list