Print Page | Close Window

DynamSubFrm.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Hookom, Duane
Forum Description: Duane Hookom's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=14
Printed Date: 28 Mar 2024 at 4:21pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: DynamSubFrm.mdb
Posted By: Duane Hookom
Subject: DynamSubFrm.mdb
Date Posted: 23 Jun 2008 at 10:52pm
This Access 2000 mdb shows how to set the SourceObject of a subform control to a query. This solution will work with a crosstab that returns a dynamic number of columns. The DAO object library is used to change the SQL property of the crosstab to remove any parameters.
 
Download Access 2000: http://www.rogersaccesslibrary.com/forum/uploads/4/DynamSubFrm.zip - uploads/4/DynamSubFrm.zip


-------------
--
Duane Hookom
Microsoft Access MVP
Eau Claire, WI



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net