🚀 go-pugleaf

Hello,

But why can't I get access to Properties collection of Field object? In
Access Help I've read that I can set these (RowSource and others) properties
through VB. Why can't I do this in my C++ app? Also when I execute query
SELECT <field> FROM <table> in Access Query Designer I get string. When I
execute through ADO I get number.

The problem is that I don't know if Row Source string array will never be
changed. If I place this array in my app I will then need to make changes to
source code and re-compile the program.

The "Ideal" way is also unacceptable because the users of my app will need
to add this new table to the database every time it is replaced by new one
(which is without this table). I mean replacing whole MDB files.

Regards,
Vladimir.

Programmer Dude <cjsonnack@mmm.com> ����� �
���������:3F661B99.F254B2B5@mmm.com...
> Vladimir wrote:
>
> > Row Source = "1; "Above"; 2; "Below"; 3; "Equal"".
> > When I try to SELECT <field> FROM <table> in my C++ application
> > through ADO, I get numeric value of the field. How can I get
> > string representation of this numeric value from the Row Source
> > property?
>
> You don't.  It doesn't exist in the table, ONLY in the Access Form
> (specifically, in the ComboBox).  I assume the BoundColumn prop is
> set to 1.  That means that when a user selects an item from the CB,
> the first column's value is put in the database field.  The second
> column values (the strings) never leave the CB.
>
> You have two choices:
>
> Ideal: create a new table containing the CB Row Source values, and
> use that to populate the CB.  When you open a recordset, open an
> SQL query that joins the main table to the new table and select
> the field containing the strings.
>
> Workable: Re-create the Row Source data in your C++ application
> and translate from the numeric value to the string.
>
> --
> |_ CJSonnack <Chris@Sonnack.com> _____________| How's my programming? |
> |_ http://www.Sonnack.com/ ___________________| Call: 1-800-DEV-NULL  |
> |_____________________________________________|_______________________|