|
|
Problem: The Textbox ControlSources (and Label InnerText Column headings)
bombs for data access pages (DAPs) based a crosstab query when the underlying
the dataset changes when we roll into a new month.
Description: I’m creating DAPs derived from crosstabs based on a rolling
12-month dataset. My problem is that as we roll into a new calendar month,
the 12-month window changes but my stored crosstab query’s headings change.
The DAP wants to keep the column heading for the month that is no longer in
the 12-month window and the textbox wants to keep the outdated ControlSource.
The ControlSource property doesn't seem to support functions, which could
programmatically point to the data source.
A full explanation of my efforts to solve the problem, including code
snippets and screenshots, is available at:
http://www.christianbahnsen.com/experiments/xtab_column_heading_problem.mht
I apologize for posting the page outside the newsgroup, but I don't see a
way to include graphics in this posting.
I have a feeling that the solution, if there is one, lies in the
AlternateDataSource property, but information about the ElementExtension
object is sketchy at best.
--
Christian Bahnsen
|
|
|