473,327 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

generic dataview flexgrid ?

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

Nov 13 '05 #1
7 5183
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
Nov 13 '05 #2
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

Nov 13 '05 #3
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

Nov 13 '05 #4
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
Nov 13 '05 #5
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

Nov 13 '05 #6
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
Nov 13 '05 #7
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


Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: VR | last post by:
I am trying to embed a check box into a FlexGrid's cell, but having a problem when I start scrolling the grid. Here is my MyCheckBox class... class MyCheckBox : CheckBox { void Init (...
9
by: JFB | last post by:
Hi All, I have a edit flexgrid, after to fill with different rows manually. How can I insert the rows of my flexgrid to my table (sql server) using ado.net? Any example? I can insert one row...
0
by: Xavier Valdés | last post by:
Hi all, I'm using component one's flexgrid (nonclassic) and I have a question... How could I drag and drop ROWS??? (from a component with my flexgrid and another component with flexgrid)...
5
by: schapopa | last post by:
I have a flex grid and I am loading data to this flex grid in this way While sqldr.Read j = j + 1 MSFlexGrid1PLSummary.set_TextMatrix(MSFlexGrid1PLSummary.Row, MSFlexGrid1PLSummary.Col,...
0
by: webmaster | last post by:
Pardon my being a total C# noob. I'm trying to take apart the dotNet Time Tracker dotNet C# starterkit sample application and replicate a part of the code. At a high level, I have a very...
0
by: alexh1000 | last post by:
When I insert the FlexGrid control in a dialog (using controls toolbar) the dialog fails to open on program execution(DoModal returns a -1). If I remove the FlexGrid from the dialog, the dialog...
3
by: Harry Haller | last post by:
Hello, I want to implement a generic list which will be used to display 7 columns in a GridView. One should be able to sort, filter and page each of the 7 columns. Ideally the filter should be...
3
by: sweevil | last post by:
I'm converting a VB6 project to .Net2005. One of the items encountered was setting the cellpicture onto a flexgrid from an imagelist. The image background doesn't appear to render correctly. I...
3
by: ArmageddonAsh | last post by:
I'm trying to make an application that will allow the user to enter data into a flexgrid (that's done) and then save the data from that flexgrid into a CSV file but even though the file is made none...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.