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 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
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
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
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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
(...
|
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...
|
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)...
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
|
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...
| |