Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Hookom, Duane
  New Posts New Posts RSS Feed - DynamSubFrm.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

DynamSubFrm.mdb

 Post Reply Post Reply
Author
Message Reverse Sort Order
Duane Hookom View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Location: Eau Claire, WI
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote Duane Hookom Quote  Post ReplyReply Direct Link To This Post Topic: DynamSubFrm.mdb
    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: uploads/4/DynamSubFrm.zip
--
Duane Hookom
Microsoft Access MVP
Eau Claire, WI
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.