Column shown dynamically in datasheet form or List box as per the availability of data in crosstab query

[ahmad_rmh]

I want to make datasheet form or List box but the columns should have to be shown in datasheet form or List box dynamically as per the availability of data in cross tab query.


suggest please.

 

[CJ_London]

Easiest way is to have a subform control on a form and set its source object to

query.mycrosstabqueryname

 

[ahmad_rmh]

Easiest way is to have a subform control on a form and set its source object to

query.mycrosstabqueryname

Doing in the same way but as the new data columns added in cross tab query the sub form just showing the old columns and not adding the new columns.

 

[arnelgp]

can you set the SourceObject of the subform to the query.yourQueryName?

//already in post#2

 

[CJ_London]

the sub form just showing the old columns and not adding the new columns

In that case you are not doing what was suggested

 

[ahmad_rmh]

Easiest way is to have a subform control on a form and set its source object to

query.mycrosstabqueryname

thanks CJ, & Arnel, Done & Solved,

Now I want to implement the same way in report.

How to implement?

 

[arnelgp]

How to implement?

the same way as in Form, you add a SubForm and on the Open Event of the Report, set the SourceObject of the SubForm.

 

[ahmad_rmh]

the same way as in Form, you add a SubForm and on the Open Event of the Report, set the SourceObject of the SubForm.

It just show datasheet form in report view, I want to show as a report view.

 

[CJ_London]

Big subject - see this link for what’s involved

access report from dynamic crosstab query and vba to "manually" generate reports

I have come across the problem of generating complex access reports (by complex I mean with data processing, variable number of fields, among others). Let me explain in deeper detail some of the th...

stackoverflow.com

 

[Pat Hartman]

I have a sample database that includes a custom form made from a cross-tab. You do need to create a report with a fixed number of columns. Access report width are restricted so 20 columns is probably all you can get on a single page width at landscape. So, keep that in mind as you are designing this. I think the max width is ~ 22" so it is two landscape pages max.

The process starts with a select query that gathers the unique values that will be columns and adds them to a table. So, for example, if your data set is expenses and those will be the column headings. The table might look like this:
1, Oil
2, Water
3, Lawn
4, Electric
5, Snow Removal

The columns of the report are bound to fields named 1,2,3,4,5 and the code in the report builds the column header fields from this table so the column names end up as Oil, Water, Lawn, Electric, Snow Removal as you would want.

Bound Denormalized Form

I've left the old versions here but ALWAYS go to the last post to get the current version. This database contains two examples (using the same technique) of how to take data that is properly normalized and display it so that it looks like a spreadsheet (rows displayed as columns) but is...

www.access-programmers.co.uk