🚀 go-pugleaf

Vladimir wrote:

> But why can't I get access to Properties collection of Field object?

You can.  Row Source is *NOT* a property of a Field.  It's a property
of the ComboBox on the Form in Access.

> Also when I execute query SELECT <field> FROM <table> in Access
> Query Designer I get string. When I execute through ADO I get
> number.

Are you saying you get "Above" in that case and "1" if you issue
an SQL statement through VC++?  That's.... impossible.  Something
else is going on.  Are you sure the Query Designer isn't linking
in a table or doing some sort of lookup?

Take a look under the hood of that query and maybe look at the
definition of the table in question.  Access can link to lookup
tables--did you design the database or did someone else?

> 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.

That's why it's non-ideal.  You could use an external text file to
initialize your program.  That would save re-compiling.

> 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.

I take it you are not supplying the MDB files (else you could just
add it yourself).


-- 
|_ CJSonnack <Chris@Sonnack.com> _____________| How's my programming? |
|_ http://www.Sonnack.com/ ___________________| Call: 1-800-DEV-NULL  |
|_____________________________________________|_______________________|