Does an Access 2000 have a datagrid facility ?

[Mel P]

I can use VB.net to import data from an access 2000 table
and display it on a datagrid using a dataadaptor etc.

I can also add a datagrid from the toolbox in Access 2000
under "additional controls" but I can't seem to get it to
work - i.e. connect via ADO to the tables.

Am I correct in thinking that the datagrid does not work
on an Access form - OR am I missing something.

Any words of wisdom welcome - thanks

Mel P

 

[Cheryl Fischer]

Access does not have a built-in Data Grid control; using Access, Sub-Forms
will provide this functionality with a lot less work. To use a data grid
in Access, you'll need to code its capabilities yourself. Here is a link to
an MSDN article with code samples:

Using the datagrid control
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/htm
l/vbconusingdatagridcontrol.asp

or

http://tinyurl.com/23vv6

 

[Mel P]

Thanks Cheryl - I'll have a go using the MS article. Mel

 

[Albert D. Kallal]

You can use what we call a continues form:

Here is some screen shots:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

 

[Dirk Goldgar]

You can use what we call a continues form:

Well, most of us call it a "continuous" form. ;-)

Sorry, Albert, I couldn't resist.

 

[Douglas J. Steele]

Well, most of us call it a "continuous" form. ;-)

Sorry, Albert, I couldn't resist.

It's the Canadian spelling, Dirk. <g>

 

[Mel_P]

Hello

I tried what Cheryl suggested - I looked at the MS page and the ADO data control worked ok but the DataGrid does not appear to have a datasource property (not that I could find anyway!

Using the MS code produced a type mismatch error fo
Set DataGrid1.datasource = adoMyADODataControl

I tried this on my Access 2002 machine and this did not even contain the ADO data control and Datagrid controls - nor could they be added in the "references" panel. I do not have VB or VB.NET installed on this machine - so it seems to me that Access does not support these controls. Perhaps they only appear on my Access 2000 machine as I have VB.NET and Vb installed. I will stick to a "continues" or even a "continuous" (sorry) subform. Thanks for your inputs all

Mel