DataGrid or flexGrid??

[Patrick]

HI!!
I've already posted these questions in the Active X chat
room, but I'm not getting any feadback, can someone help
me?

I've got 2 questions!

first, Im trying to send to the ControlSource of a
dataGrid an SQL query, like this:

s = "SELECT * FROM [t 03/04 Data(03-Sep-22)]"
flexBck.ControlSource = s

But it does'nt allow me to do-it,WHY?

Can this be done with a datagrid or would-it only work in
a flexGrid.

Second, For the FlexGrid, I can select-it from the insert
menu -> active X controls, but it wont allow me to install-
it on my form,WHY? do I need a better version of access
2000, like developer,to have access to-it.

Every time I try to do that,this message pops-up:
"The OLE server isn't registered. To register the OLE
server, re-install it."

Can I do that, and How?

 

[Albert D. Kallal]

HI!!
I've already posted these questions in the Active X chat
room, but I'm not getting any feadback, can someone help
me?

I've got 2 questions!

first, Im trying to send to the ControlSource of a
dataGrid an SQL query, like this:

s = "SELECT * FROM [t 03/04 Data(03-Sep-22)]"
flexBck.ControlSource = s

I the dataGrid control does NOT allow you to directly specify the sql
source. You also need to use a ADO connection object (a data object) to make
the above work. I would not really want to start using data objects in
ms-access. If you plan on doing that, you might as well dump ms-access, and
use VB.

For a reference on using the data grid control, check out:

http://support.microsoft.com/default.aspx?scid=kb;en-us;208283&Product=acc


Any reason why you don't just use a continuous form? Continues forms are
regular forms in ms-access, but all controls "repeat" and thus you get a
grid.

Take a look at the following screen shots: the following is REGULAR
ms-access forms with NATIVE controls, and no active x is needed.

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

After viewing the above, I sure you will agree that you don't often need a
data grid contorl.