Ms Flexgrid Control

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

JamesJ

I know I should be posting this to ...activexcontrols but I posted on the
8th
and haven't received a reply (must be busy) so I'll try my luck here if the
community don't mind.

I'm trying to populate the MSFrexgrid control with a table from my back-end
mdb.
Article in the msdn didn't seem to help there was no step-by-step articles
for
me to check out.

In the OnLoad of the form I put:
Me!axcFlexGrid.RecordSource=Me.RecordSource.

When I open the form I get:
Object doesn't support this property or method

Should I be connecting the control to the db first, and if so how?
Any help will be appreciated.

Thanks,
James
 
The same thing applies to this control as with the data control you posted
about before. I don't have it on my A2K box, and a search of MS for acc2002
msflexgrid returns no hits. I may be going mad but I'd suspect that they're
not working purely because they're not supposed to.

I'd also suspect that, in both cases, you don't actually need to use ActiveX
controls. I think I can count on the fingers of one hand the number of
times I've needed to. I'd suggest reposting here just saying what it is
you're trying to achieve with them.
 
I was just trying something a bit different to view my data. I'm currently
using continuous forms but I must use functions to accomplish such
things as sorting by different columns and setting the cursor to an arrow
in the MouseMove, etc.
I'm considering going back to using the Listbox(s) I like viewing the data
in columns and rows.

Thanks much,
James
 
The problem is that MsFlexgrid likely needs a ADO reocrdset, and your
recordset might be DAO??

ms-access tends allow DAO, or ADO reocrdsets (for example, the forms
recordset property can be ADO, or DAO, depending on what kind of variable
you declare the recordset as.

The MsFlexgrid has no such ability.......

As others mentioned, using a listbox, or a continues sub form is often a
alternative. Take a look the following screen shots of mine where I make the
case for using continues sub-forms in place of a grid control.

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm
 
im using access 2003 on Win2K3 Server

and I have the need to populate a list control of some sort from a
query.

I want the query to be completed by the value of a combo box (which is
a list of last names)

Once the user selects a last name, I want the list control to be
populate with records based on the last name.

Then have the user select the record they want. The id of that record
will populate a field on another form.

Can someone direct me to an example of populating a list box with
records from a query?

I can bind my combo box from a query, but that was the easy part.
 
Set the list box's RowSource property to the name of the query (with
RowSourceType set to "Table/Query")
 
Albert,

Thanks for the boost of confidence with your suggestions of list boxes and
continuous forms.

I have a situation that I think the above will work for, EXCEPT for a few
simple requirements, that, as it turns out, are not so simple. Any ideas
would be appreciated if you still think the list box/continuous forms is the
way to go:

Ability to select/deselect fields which will display on the form
Ability to drag and field and "drag" update other records down the grid
Sort on a column
Directly update data (I know this can be done)
Use the data presented as the data source for a report, with the ability to
check a box next to the record to deselect a record after the filter is
applied, from showing on the report
 
Back
Top