Crosstab Query in Flex Grid

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   This demo program shows how to display a Crosstab query in a Flex Grid control on a form. The problem with displaying Crosstab queries on a form (say in a ListBox control) is that some queries have a variable number of columns as well as rows. Using a Flex Grid control allows you to set the number of columns at run time as well as giving all the other facilities that you get with Flex Grid controls such as colouring cells, fixing columns or rows, etc, etc.

See my other demo for more information on Flex Grid commands.

This demo works with Access 2000 onwards.

uploads/20/Crosstab_FlexGrid_Demo.zip

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Peter Hibbs Members Profile Send Private Message Find Members Posts Add to Buddy List Contributor Joined: 29 Jun 2008 Status: Offline Points: 10	Post Options Post Reply Quote Peter Hibbs Report Post Thanks(0) Quote Reply Topic: Crosstab Query in Flex Grid Posted: 09 Sep 2008 at 3:49am
	This demo program shows how to display a Crosstab query in a Flex Grid control on a form. The problem with displaying Crosstab queries on a form (say in a ListBox control) is that some queries have a variable number of columns as well as rows. Using a Flex Grid control allows you to set the number of columns at run time as well as giving all the other facilities that you get with Flex Grid controls such as colouring cells, fixing columns or rows, etc, etc. See my other demo for more information on Flex Grid commands. This demo works with Access 2000 onwards. uploads/20/Crosstab_FlexGrid_Demo.zip
	-- Email: pdh_software@btinternet.com This software is freely available to any Access user.

Sponsored Links