generic dataview flexgrid ?

[tombsy]

Hi gang...
I want to have a form that can display data from a datasource that is not
fixed.
lets say a crosstab query that can change the number of colums and field
headings depending on the result.
So, I cant have a normal form based on a table or query.

I want to use something like the MSFlexgrid or Datagrid to display a dynamic
result set.

I can do it in VB but I want to do it on an Access form. How can Ido this ?

Has anyone out there used the flexgrid on an access form, if so, how as the
contol properties seem to be differnt in Access as they are in VB


All reponses greatfull

thanks

Tombsy

[Bas Cost Budde]

tombsy wrote:

Hi gang...
I want to have a form that can display data from a datasource that is not
fixed.
[...]
Has anyone out there used the flexgrid on an access form, if so, how as the
contol properties seem to be differnt in Access as they are in VB

I have tried but was so unsuccessful I went to manipulating the form
design instead. If the number of fields doesn't vary too much, you could
even include some extra controls, and assign those when appropriate.

Would you like me to expand on that?

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[tombsy]

Thanks bas

I can do form manipulation, but specifically want to see if the flexgrid
will work.
The thing that I cant solve is that the "recordsource" property of the
flexgrid in Access is missing.


"Bas Cost Budde" <b.*********@heuvelqop.nl> wrote in message
news:cn**********@news2.solcon.nl...

tombsy wrote:

Hi gang...
I want to have a form that can display data from a datasource that is not
fixed.
[...]
Has anyone out there used the flexgrid on an access form, if so, how as
the contol properties seem to be differnt in Access as they are in VB

I have tried but was so unsuccessful I went to manipulating the form
design instead. If the number of fields doesn't vary too much, you could
even include some extra controls, and assign those when appropriate.

Would you like me to expand on that?

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[Phil Stanton]

Guess it can be done.
I have done it with a report based on a Crosstab query where the number of
columns changed to reflect the number of columns in the query. As far as I
remember, you have to create a new query with the crosstab query as its
source and delete the old report and create a new one using lots of
CreateReportControl or in the case of a form use CreateControl.

My code is slightly shorter than the Bible, but not much - so be warned

HTH

Phil
"tombsy" <ic*****@tiscali.co.uk> wrote in message
news:41**********@mk-nntp-2.news.uk.tiscali.com...

Hi gang...
I want to have a form that can display data from a datasource that is not
fixed.
lets say a crosstab query that can change the number of colums and field
headings depending on the result.
So, I cant have a normal form based on a table or query.

I want to use something like the MSFlexgrid or Datagrid to display a
dynamic result set.

I can do it in VB but I want to do it on an Access form. How can Ido this
?

Has anyone out there used the flexgrid on an access form, if so, how as
the contol properties seem to be differnt in Access as they are in VB


All reponses greatfull

thanks

Tombsy

[Bas Cost Budde]

tombsy wrote:

Thanks bas

I can do form manipulation, but specifically want to see if the flexgrid
will work.
The thing that I cant solve is that the "recordsource" property of the
flexgrid in Access is missing.

I am unfortunately unable to test this for myself, because I cannot find
the grid control in my installation. Was that A97 anyway? If it is not
in the toolbar, where could I look?

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[tombsy]

Its in the extended "more controls" toolbar list as "Microsoft Flexgrid
Control version6"

"Bas Cost Budde" <b.*********@heuvelqop.nl> wrote in message
news:cn**********@news2.solcon.nl...

tombsy wrote:

Thanks bas

I can do form manipulation, but specifically want to see if the flexgrid
will work.
The thing that I cant solve is that the "recordsource" property of the
flexgrid in Access is missing.

I am unfortunately unable to test this for myself, because I cannot find
the grid control in my installation. Was that A97 anyway? If it is not in
the toolbar, where could I look?

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[Bas Cost Budde]

tombsy wrote:

Its in the extended "more controls" toolbar list as "Microsoft Flexgrid
Control version6"

:-( No, not with me. And whatever I try nothing but errors and
"registration issues". That's not my strong point.
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[David Schofield]

Hi
You can use a normal continuous form and bind the sources in the load
event. There is a kb article on this somewhere, or maybe it is in the
ms sample databases (for a report actually but works on forms as well
of course). A ref I could find on Google is
http://www.blueclaw-db.com/report_dy...stab_field.htm
David

On Thu, 18 Nov 2004 19:51:37 -0000, "tombsy" <ic*****@tiscali.co.uk>
wrote:

Hi gang...
I want to have a form that can display data from a datasource that is not
fixed.
lets say a crosstab query that can change the number of colums and field
headings depending on the result.
So, I cant have a normal form based on a table or query.

I want to use something like the MSFlexgrid or Datagrid to display a dynamic
result set.

I can do it in VB but I want to do it on an Access form. How can Ido this ?

Has anyone out there used the flexgrid on an access form, if so, how as the
contol properties seem to be differnt in Access as they are in VB


All reponses greatfull

thanks

Tombsy